which database should be used in which requirement and how ?

D Dasawari

11y987.NET

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.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Inathi Gqola11y ago
Accepted 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.
+1
Inathi Gqola11y ago
Hi D,

This and this will help you solve your connection problems.

Cheers!
0
D Dasawari11y ago
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 ?
0
D Dasawari11y ago
Which one should I download now among them ? http://www.microsoft.com/en-in/download/details.aspx?id=29062
0
Inathi Gqola11y ago
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.
0
D Dasawari11y ago
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
0
Inathi Gqola11y ago
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 .
+1