which database should be used in which requirement and how ?

Question

which database should be used in which requirement in C# ASP lang and how to connect with various databases using C# ASP lang ? Please explain step wise and or any link to look over this issue.

Inathi Gqola · Answer

Hi D Microsoft SQL Server Express is free and a good choice. Check under system requirements if your computer meets the requirements you can then proceed to download and install! Enjoy.

Inathi Gqola · Answer

Hi D You can connect to several DBMS's using ASP.NET but I will tell you about MS ACCESS and MS SQL SERVER . You would want to use MS ACCESS when; You don't have a lot of people accessing your database at the SAME TIME (say a thousand people or so) You have the MS OFFICE SUIT installed and you don't want to pay for another DB package. You are a beginner and not worried about the reliability scalability etc. (Access servers are known to crash under a lot of pressure or when the client's computer crashes. Also expect downtime during database maintenance.) You are a beginner and you just want to learn SQL (queries triggers stored procedures etc) You are a beginner and want to learn OOP concepts. Here is a nice step by step tutorial to help you connect to an Access DB using C#. You would want to use MS SQL SERVER when; You are developing enterprise software where security and speed are very important. You are confident that your application will have a lot of people accessing your database at the SAME TIME. You will be storing a lot of data in your database (esp attachments). You are willing to pay for the SQL SERVER package. Here is a nice step by step tutorial to help you connect to a SQL Server database. Happy Coding! NB: It would be a lot easier for people to help if you told us the 'requirements' that you are talking about .

Inathi Gqola · Answer

Hi D This and this will help you solve your connection problems. Cheers!

D Dasawari · Answer

error while connecting like A Network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible.Verfy the instance name is correct and the SQL Server is configured to allow remote connection. (provider: Named Pipes provider:40-could not open a connection to SQL Server) (Microsoft SQL Server Error:53) . How to resolve it ?

D Dasawari · Answer

Which one should I download now among them ? http://www.microsoft.com/en-in/download/details.aspx?id=29062

Inathi Gqola · Answer

Hi again D It depends on what you want to achieve with your application. If it is just to familiarize yourself with Visual Studio and SQL Server . Then yes VS 2013 Express for Web does come with a local DB. Here is a walkthrough to creating a local database file. Or you can alternatively download SQL Server Compact . Which is a free edition of MS SQL Server just like MS Visual Studio 20XX Express for Web is a free edition of Visual Studio. Assuming your aim is to familiarize yourself with C# and MS SQL Server here is a link to help you choose between the two.

D Dasawari · Answer

Will I have to install MS SQL Server database separately ? or either Does It come inbuilt with MS Visual Studio 2013 express for web ? I am beginner to it  please explain how to use it and connect as well