When I get around to creating, and filling out, a new ClickStart volume on X# I do intend to have a full section on SQL and cover as many common and different forms of SQL engine as possible. Light, local, and full blown servers.
I will need help from Johan, and guys like yourself to contribute - help, advise and test what I do.
But till then why don't you download a free Express version of MS SQL Server and try things out? - it should co-habit quite nicely.
Speak soon,
And don't forget that you are now a volunteer ;-0)
Phil.
I cannot speak for Karl, but I for myself try to keep my work machine as clean as possible - and a running SQL server is not a thing I like.
For such things I would rather setup a test machine (for example I have a cheap notebook with enough memory as database server to play with).
Wolfgang
Wolfgang Riedmann
Meran, South Tyrol, Italy
wolfgang@riedmann.it
https://www.riedmann.it - https://docs.xsharp.it
Wolfgang,
my thoughts <g>.
That said, i installed, i think Postgres 8.1 years ago, upgraded every now and then, so on my desktop machine runs a fullblown server in the background, without me noticing anything of its existence. Added Database.net from fish (taiwan) as frontend for every ad hoc things to play and try with - and that's enough...
Regards
Karl
(on Win8.1/64, Xide32 2.20, X#2.20.0.3)
I have too a license to Fish's Database.NET, but I like Navicat Premium Essentials a lot more because it supports a https tunnel connection to my MySQL servers (for security reasons I don't open the MySQL ports to the internet, and with the tunnel I can manage them from my local machine as well).
Wolfgang
Wolfgang Riedmann
Meran, South Tyrol, Italy
wolfgang@riedmann.it
https://www.riedmann.it - https://docs.xsharp.it
Did you ask Fish to add the functionality? Although communication is sometimes a bit strange, due to language diffferences , i found him very fast reacting for bugreports and/or useful enhancements.
Regards
Karl
(on Win8.1/64, Xide32 2.20, X#2.20.0.3)
no, never asked. Since I have Navicat already that also has some more functionality I don't need it anymore.
The version I have (Premium Essentials) is a stripped down and cheap version of their fullblown and expensive Premium version: https://www.navicat.com/products/navicat-premium
The Essentials version costs 160 $, the full version 998 $ (for all supported database engines), so I think the Essentials version is very good value. The Essentials for Postgres alone costs only 40$.
Wolfgang
Wolfgang Riedmann
Meran, South Tyrol, Italy
wolfgang@riedmann.it
https://www.riedmann.it - https://docs.xsharp.it
I will need help from Johan, and guys like yourself to contribute - help, advise and test what I do.
Sorry for late reply, but although following what is going on when I can, just have some difficulty currently with my eyes and it puts a lot of strain on me functioning at the moment. Docs a bit baffled as they are unable to identify the cause. Speculating it might be early sages of Multiple Sclerosis or just stress. In the meantime I am trying to eliminate as much as possible in my diet that can be a cause, and upped intake of food related to proper nerve functioning.
Sure I will contribute regarding SQL and PostgreSQL where I can. It is not that much different from other SQL dialects and the Npgsql driver do have support for Linq, have not tested it, but it is integrated and build on the .net abstract classes and interfaces required that SQLServer is also build on.
Regards,
Johan
.
______________________
Johan Nel
Boshof, South Africa
Thanks for the current information and heads up concerning your health.
I do hope it works out better for you than it may seem at the moment - good luck! And fingers crossed.
Yes, I will get back to you in a few months regarding the other flavours of SQL, other than MSSS.
Glad to hear that Npgsql has a driver to make LINQ possible, that's a good start, and facilitates Entity Framework design and use. In which case there should be no syntax conflict after making a connection and setting the driver up correctly - since T-SQL script is generated by the driver itself.
At the moment I have picture frames to complete, before going North for a visit to family and friends - oh! and a big wedding anniversary, going to the Lake District for a few days.
This morning I will 'move-on' my current demo app for EF6 and Michael and anyone else interested.
enjoy the wedding anniversary. You set the pace and I will try to follow. As it is all documented I think we should be safe and followers that might join later as well.