Database sharing between two applications in .NET

Question

1.80/5 (2 votes)

See more:

I am using a form application and a web application using .net(SQL server database) and i want to share the database between form application and web application. i.e. changes made in the database from any one application should be reflected in other. What are my options to implement the same?

I have a little idea about Web service(just the concept). Also let me know if the same can be used for this purpose(database sharing)and if so, how? Any other solution is otherwise welcomed. Thanks. :)

Posted 24-Feb-14 22:04pm

Dean_Wi

Updated 24-Feb-14 23:10pm

v2

Add a Solution

Comments

Charan_Kumar 25-Feb-14 4:07am

1) you have write two connections string in web.config. (or)
2 you may use triggers

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)

**Joezer BH** · Answer 1 · 2014-02-24T22:16:00

Solution 1

See:

* [MSDN] How to: Create and Run a CLR SQL Server Trigger[^]
* [c-sharpcorner] create-your-first-clr-trigger-in-sql-server-2008-using-C-Sharp/[^]

See also CP article: Triggers -- SQL Server[^]

Cheers,
Canny

Posted 24-Feb-14 22:16pm

Joezer BH

Updated 24-Feb-14 22:19pm

v3

Comments

Dean_Wi 25-Feb-14 5:05am

you just mentioned about using triggers for after events in the database. but i don't get how that would help to retrieve the changes made in the database from another application! :/

Joezer BH 25-Feb-14 5:28am

What do you mean by retreive the changes?
If you want you can view the log files changes made on a DB, but I doubt you would want to do that...

If you want to pass specific data between the processes, you can implement a messaging technique between the two application (possible via a the DB itself) or some other IPC method which would be more efficient than using triggers.

Maciej Los · Answer 2 · 2014-02-24T22:47:00

I'm not sure what you mean "i want to share the database between form application (..) changes made in the database from any one application should be reflected in other"...

Have a look at SQLDependecy class[^].
Here is an sample implementation: Using SqlDependency for data change events[^]

For further information, please see:
Detecting Changes with SqlDependency[^]
Using SqlDependency in a Windows Application[^]
SqlDependency in an ASP.NET Application[^]

[EDIT]

If you don't know how to set up instance of SQL Server to listen network connections, please read this:
Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager)[^]
Configure a Server to Listen on an Alternate Pipe (SQL Server Configuration Manager)[^]
Note: sometimes it's necessary to configure firewall
Configure the Windows Firewall to Allow SQL Server Access[^]

[/EDIT]