How to create a distributed database application in C#

Question

1.00/5 (1 vote)

See more:

I am new in c# and sql server programming and am also doing my research thesis in distributed database. I want to know how to create a distributed database application with replication so there is a server and client where data in the server database is replicated into the client database. I am short of ideas and I need help. If possible any available source code.

What I have tried:

I am very new so I have not tried anything yet

Posted 5-Feb-19 19:02pm

MaximusDebois

Updated 5-Feb-19 20:00pm

Add a Solution

Comments

Richard MacCutchan 6-Feb-19 4:54am

If this is a research thesis then you do not need to know either C# or SQL. Your thesis is (according to you) about distributed database, so that is what you should be focusing your research on. The theory is far more important than the actual implementation.

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 · 2019-02-05T20:00:00

This is a very, very complex subject, and not one that can be covered in a little text box. Start here with a simple overview: Data Replication in Distributed System[^] and then follow some Google links: distributed database replication - Google Search[^]
This is not a trivial project, not even slightly, and it is one that requires serious thought before you start implementing it as the database has to be designed from the start to support this. Will you find "available source code" that will exactly fill your needs? No, almost certainly not!

V. · Answer 2 · 2019-02-05T19:40:00

I'm not sure what your architecture is, but is it desired that all clients have the same data as the server or is it more a local repository and the server is the sum of different repositories?

You might want to consider if you want to push or pull data.
How do you wish to transfer the data: Via the SQL-Server itself (I'm pretty sure there is a way to do that) or through C# code.

Both through the database directly or through code I would start at looking into different sync options that already exist (google is your friend here), writing it yourself is not a trivial task.

I think you'll need to clarify your functionality first before diving into the sync options.

Hope this helps.

How to create a distributed database application in C#

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0