How to sync Data of 2 c# projects?
-
Hello experts, I would like to ask how will I sync the data of 2 C# projects I created. I created a windows form application which use sql server 2005 express as its database and I also create an asp.net website that uses sql server 2005 express(The asp website and its database is uploaded to a hosting site). Any comments or suggestions are kindly appreciated. Thanks, DAN
-
Hello experts, I would like to ask how will I sync the data of 2 C# projects I created. I created a windows form application which use sql server 2005 express as its database and I also create an asp.net website that uses sql server 2005 express(The asp website and its database is uploaded to a hosting site). Any comments or suggestions are kindly appreciated. Thanks, DAN
You best bet would be to create a
WCFservice that resides on your websites server. Then both Windows application and Website can access the same database, or the windows app could use it's own database, and only update the main database on the Webserver occasionally....and I have extensive experience writing computer code, including OIC, BTW, BRB, IMHO, LMAO, ROFL, TTYL.....
-
You best bet would be to create a
WCFservice that resides on your websites server. Then both Windows application and Website can access the same database, or the windows app could use it's own database, and only update the main database on the Webserver occasionally....and I have extensive experience writing computer code, including OIC, BTW, BRB, IMHO, LMAO, ROFL, TTYL.....
Hello, Thanks for the immediate reply, I would like to ask again. If I create a wcf service in my asp.net website do I still need my windows form application database? Thanks, DAN
-
Hello, Thanks for the immediate reply, I would like to ask again. If I create a wcf service in my asp.net website do I still need my windows form application database? Thanks, DAN
That would depend on your requirements. Personally, I like to use a separate database for the Windows application, which would be a local data cache, which can periodically update the main database. This way, if there are any connectivity problems with the Windows application, the users can still carry on. Hope this helps.
...and I have extensive experience writing computer code, including OIC, BTW, BRB, IMHO, LMAO, ROFL, TTYL.....
-
That would depend on your requirements. Personally, I like to use a separate database for the Windows application, which would be a local data cache, which can periodically update the main database. This way, if there are any connectivity problems with the Windows application, the users can still carry on. Hope this helps.
...and I have extensive experience writing computer code, including OIC, BTW, BRB, IMHO, LMAO, ROFL, TTYL.....
Hello, Thanks alot, got a big idea on what you said :) I forgot that it might cause trouble if I use only the database of website. Would you mine if you could give some link about wcf services for my asp.net website. Thanks, DAN
-
Hello, Thanks alot, got a big idea on what you said :) I forgot that it might cause trouble if I use only the database of website. Would you mine if you could give some link about wcf services for my asp.net website. Thanks, DAN
You could start with this MSDN article about Hosting and Consuming WCF Services[^]. I leave the rest to you. Good Luck.
...and I have extensive experience writing computer code, including OIC, BTW, BRB, IMHO, LMAO, ROFL, TTYL.....