How do I load database independent SQL SERVER and WEB SERVER

Question

1.00/5 (2 votes)

See more:

Hello everybody,

How to create an project that load a database from itself?

For example, I have ASP .NET WEB FORMS project or MVC and I create database with SQL MANAGEMENT STUDIO and than I copy this database in app_data folder of my project.
Then I create DataGrid and I want to load data in DataGRID from app_data database,not SQL SERVER . Can I eliminate SQL SERVER?
Must I change connection string or what must I do to make a database independent fromWEB SEVER and SQl Server????
If it is not possible, how to make my project create database locally on another PC and run from there my project???

Thanks in advance.

Posted 1-Oct-15 7:59am

Member 11891291

Updated 1-Oct-15 8:03am

v3

Add a Solution

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)

OriginalGriff · Answer 1 · 2015-10-01T08:28:00

Um...yes...in theory you can use the database directly. But...it's a very silly idea.

Web sites are intrinsically multi user, and directly accessing the file (which means treating it as a JET or ACE db) means that you lose the advantage of SQL server: multi user access. And every system I've ever worked on which accessed databases directly has had major intermittent problems when multiple users are involved. You can work round them, but it's clumsy, slow, and you have to remember to do it every single time you try to use the DB.

I would use SQL Server - the Express version will probably do - and save myself a lot of problems.

Wendelius · Answer 2 · 2015-10-01T08:53:00

As already pointed out I also believe that using Sql Server would be a benefit in your application. It doesn't make any sense to create a database but not use the database management system.

On additional point of view is that if you later start load balancing the web servers you need to place the data-tier properly on a separate server. Having two completely isolated database files on separate web servers would cause a serious problem.

How do I load database independent SQL SERVER and WEB SERVER

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0