How to use attached DB file in LAN application without Sql server

Question

0.00/5 (No votes)

See more:

, +

Hello All,

Here is the description of the case i am stugging on:
I have an application developed using .net C# and uses attached Db file with it without any SQL server in its App_Data folder named as Database1.mdf and Database1.ldf, i can successfully connect with my local application, but i am worrying about the plan after Sale out my application because this application is suppose to run in LAN.

So i need help upon following points.

1: How to use this file after installation on client machine in the machine where it will be installed.
2: How other computer will be connect to this app.
3: Do I need to install anything else than application only to use this file in both server and client computer.

Thanks.

Posted 10-Oct-13 23:08pm

Banci Gurjar

Add a Solution

Comments

Prasad Khandekar 11-Oct-13 5:33am

Hello Banci,

What you are doing is good for development. From installation perspective, I suggest you use some good installer. All installer's allow you to executes DDL required to create your database and DML's to pump the pre-load data. The installer should ask for the database details to connect to.

If installer is not an option then you can simply bundle the necessary DDL's & DML's along with your application files in a simple zip format. Keep a readme.txt containing instructions on how to configure the application and create the database using accompanied DDL's & DML's. The last step will be to ask user to enter the database details in your app config. file.

I think you are talking about SQL Server CE, in which case it's not really suitable for the intended use. You should either use the SQL Server Express or SQL Server. (http://technet.microsoft.com/en-us/library/bb380177%28SQL.90%29.aspx)

Regards,

Banci Gurjar 11-Oct-13 5:38am

Prasad Khandekar thank you so much for your reply, no doubt your suggestion works, but do i need to create separate file for each installation in LAN, or it is fine if it is installed on a single machine only ?

Prasad Khandekar 11-Oct-13 6:25am

Hello Banci,

I have updated my comments. The short answer is SSCE is not suitable for the way you want to use it. It allows multiple connections from same application but multiple applications accessing the same data file is a no no.

Regards,

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)