How Do I Use Sql Server In Asp.Net?

Question

1.00/5 (2 votes)

See more:

Hello, i want to use sql server in my application. i.e, i need a database with security(username and password but i don,t know how to archieve that because i don't want to use localdb. Pls, help

Posted 1-Aug-15 1:36am

Member 10285969

Add a Solution

Comments

[no name] 1-Aug-15 16:20pm

You might want to update your "question" with non-contradictory information. You say you don't want to use localdb but then are using it but don't know how to copy paste a file. Think for a bit about what it is that you want to do, then explain that to us and you might get a meaningful answer instead of all of this confusing back and forth trying to get you to tell us what the problem is.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Afzaal Ahmad Zeeshan · Answer 1 · 2015-08-01T01:49:00

Although this article of mine is not about ASP.NET, but it gives you an overview of connecting to SQL Server using C#. How to connect SQL Database to your C# program, beginner's tutorial[^]. You should consider learning a few concepts for SqlClient[^] namespace first, generally, it is this class that is used to connect to and execute commands on SQL Server. SqlConnection, SqlCommand, SqlParameter and many more are objects declared in this namespace.

Chances are that you will be able to write your own connectors to connect to SQL Server and execute your own statements. In ASP.NET, Entity Framework is a good framework to work with SQL Server, EF allows you to focus on your logic and abstract the data manipulation layer and leave it to .NET framework. Read Solution 1 by Mika for that.

Edit

Since you are developing the application, it is good to use localDb rather than purchasing a SQL Server license and installing an entire server to run it. You should understand that even running SQL Server Express requires you to install the server, without it, your database won't work. LocalDB is a very compact edition (just as a personal tip, I think that SQL Server CE was upgraded to SQL Server LocalDB, because Microsoft is no longer publishing SQL Server CE officially), and LocalDB comes shipped with a few required files and assemblies (just similar to SQL Server CE) which are needed to run your database.

Then, on the hosting environment you can create a database there. IMO, it is better to create a new copy of database on their server rather than deploying your database files there. Many problems of authentication and similar raise when you try to deploy your application on server.

For these reasons, I would suggest that you continue programming and development with LocalDB, and when your web application gets deployed on hosting environment, you should run a script to generate a database file based on the environment. :-)

For more on LocalDB, read this[^]. I enjoy SQL Server LocalDB, after Microsoft stopped support for SQL Server CE. They save a lot of time and I don't even have to run any background server to get the data.

You should also note that hosting providers usually do not support LocalDB, they provide you with a licensed copy of either SQL Server 2008-2014.

How would I upload the database? As I said, you should not. You are not sure of what assemblies you will be provided on hosting environment. For this sake, I said create a new database on the server end when you upload your files there. Do that manually or by script.

As Mika has mentioned, LocalDB is not intended for commercial use you would require to get a copy of SQL Server, but a better choice is to search for a copy of SQL Server on the hosting server. Other features, such as advertising, payment processing is a totally different thing to talk about. :-)

Wendelius · Answer 2 · 2015-08-01T01:40:00

Solution 1

There are a lot of tutorials available depending on your needs. For example:
- Using SqlClient classes Beginners guide to accessing SQL Server through C#[^]
- Entity Framework with MVC Getting Started with Entity Framework 6 Code First using MVC 5[^]
- and simply EF Entity Framework Tutorials[^]

Posted 1-Aug-15 1:40am

Wendelius

Comments

[no name] 1-Aug-15 10:09am

I am not talking about learning to code. I know how to do those but its with localdb. And as it is, localdb is not secure and cannot be pushed into production. I have created an application with models but no database because i dont want to use localdb. I tink u get my point

Wendelius 1-Aug-15 10:20am

I don't quite understand your question. If you want to use full SQL Server instance then install it on a server hand modify the connection string for the SqlConnection to point to the centralized SQL Server database. If you use EF then modify the configuration file to contain correct connection string...

Thanks7872 1-Aug-15 12:32pm

Then provide credentials of the server where you want to host the db. All you need to do is to make change in connectionstring.

[no name] 1-Aug-15 13:21pm

I'm sorry for the misundestanding. Please, correct me if i am wrong. For example, i need a secure database, then i start to code with the default database(localdb). Then when i am tru with the application, i then upload it to a hosting website. How will i upload the localdb to the host server. (also securing the database)

Wendelius 1-Aug-15 13:55pm

I'm sorry but I don't still understand. Localdb is meant for single user applications with local data store without transactions. Other versions of SQL Server offer centralized database for multi user purposes.

For example when I develop SQL Server applications I always install the SQL Server edition I want to use in the end and develop using that edition. Each edition behaves a bit differently so for example starting with localdb and then switching to standard edition may cause side-effects to your program (consider for example the transactions).

Then about the hosting web sites, are you talking about Azure? If that is the case, I would make the development using it from the beginning, again there are differences....

[no name] 1-Aug-15 16:15pm

Thanks for explaining it in this length. You've tried for me.
One more thing:
if i want to clone a site like facebook that handles advert payment,messaging etc.; will coding with localdb be a good idea?

Wendelius 1-Aug-15 16:52pm

Localdb is meant to be used only in lightweight, single user, small amount of data databases so anything that runs a website should be built on other editions of SQL server than localdb.

[no name] 2-Aug-15 0:38am

Thanks. You,ve just answered my question. Thank you for your time. I'm more appreciative

Wendelius 2-Aug-15 0:44am

You're welcome.