How to store and access the database in .net desktop application?

Question

0.00/5 (No votes)

See more:

, +

Hello,

I made an application(used : C# win form, sql server 2008 r2).

Now when I goes for the marketing and want to give the demo version to client I have to install the sql server also.

Everytime installing the Sql sever is an headach to me, it take lots of time.

Can any one give any solution how can I store database in my application only?

Thank you to all.

Posted 27-Jun-14 21:48pm

DT_2

Add a Solution

3 solutions

Add a Solution

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

OriginalGriff · Answer 1 · 2014-06-27T22:07:00

If you are using this for a single user, then SQL server is a very poor idea.
Consider changing your code to use SQLite, or SqlCE (or even Access) instead, unless you really need multi-user access.

If you need multiple users, then SQL server it is - and that means that your application needs an instance of SQL server on the network and accessible when it runs - there is no way round that, so if it isn't there, you will have to install it. You could change to MySql, but that needs a server installation as well, so it wouldn't change your problem in any way.

Nguyen.H.H.Dang · Answer 2 · 2014-06-30T16:58:00

Solution 3

Why should you re-install server many times ???

Please use only 1 server. And on Client's PC, change "connection string" only, so you can connect to your server through the Internet.

Posted 30-Jun-14 16:58pm

Nguyen.H.H.Dang

Comments

DT_2 10-Jul-14 3:51am

Mr. Dang, I have to market and give the demo to client, and also have to give them a demo version of my application, so how can i use your way?

Nguyen.H.H.Dang 10-Jul-14 4:27am

My solution just like Solution 1 and Solution 2 here, read and think about it please.

Pravuprasad · Answer 3 · 2014-06-27T23:24:00

Solution 2

simple while installing database(sql server) make sure it's available for network also .
and in ur application connection string give the data source as the machine ip and give credentials for connecting to database .And run ur application wherever u want .

Posted 27-Jun-14 23:24pm

Pravuprasad

Comments

DT_2 28-Jun-14 6:32am

I didnt get it?
Are you getting my point what i want?how to use my office network on different different location(pune, mumbai, nashik?)?

Mr. Pravuprasad I want to store database into my application only.

Pravuprasad 28-Jun-14 6:44am

try to get the point what i'm saying.While installing sql server in the server(Which will keep your sql server database) make sure global access to server is enable . And after doing this by giving your global ip (machine which contains your sql server ) as data source you can access your database globally,what ever that place is pune,mumbai,nashik,etc)
And if you can't store database in application . (for this you have to use sql express or other light weight dataserver)

How to store and access the database in .net desktop application?

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0

How to store and access the database in .net desktop application?

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us