Starting Database Programming

[Steve25]

I need to start learning database programming with C# (creating databases as well as modifying existing ones) and VS tools. I'm not entirely sure however which database language and tools to start with. I was thinking of using MySQL because it's free and fairly popular so there will be a lot of tutorials. However isn't it hard to deploy with? Any suggestions will be a great help

[monalin]

My personal preference is using some version of MSSQL. You can obtain a free copy of SQL Server Express Edition from Microsoft's website and you can even include it in your deployments as a prerequisite and it will be installed automatically on the client's machine if needed.

Anyways, Visual Studio and C# are from Microsoft so is MSSQL using the two together will alleviate some problems you may run into using MySQL in conjunction with Visual Studio and C#. By default there is no support in C# for MySQL you'd need to download the .dll's from MySQL's website and include them in your project. Then, you'd need to write a wrapper class that will, for lack of a better term, plug-in to the rest of the code. Theres nothing wrong with using MySQL but its a lot less work to use MSSQL.