please help me,my project.........
-
Dear friends: My team has the following task to complete.A solution that consists of 3 projects : 1-Win app that connected to a local DB server(SQL server) . 1-Web app that connected to a remotre server(SQL server). 1-Mobile app for that connected to tha same remote server of the web app. The Details: 1-The win app deals with a DB(Local DB SQL server) for updating ,retriving,inserting and deleting. 2-The web & the mobile app deal with a DB(Remote DB SQL server) for tha same purpose.(updating ,retriving,inserting and deleting) The Goal: 1-The Win app will connect one time per day to update the Remote SQL server with the new data from the Local SQL server. 2-The Web and mobile app connected to the Remote SQL server will update ,retrieve ,delete and insert records in it. The Questions: 1-If I can use Asp.net web services ,How can I use it? 2-How can i make daily transaction to update the Remote SQL server with the new data at the Local SQL server?? 3-How can i make daily transaction to update the Local SQL server with the new data at Remote SQL server ?? 4-How can i manage the DB Transactions ? 5-how can i use the same methods(code) for dealing with the DB ,for the win app , the web app and the mobile app? 5-What is the best way to complete this solution? Thanks for reading to this line. I hope you can help me. thanks again. Best Regards Ahmed Gaser FCSIS IS Dept.
-
Dear friends: My team has the following task to complete.A solution that consists of 3 projects : 1-Win app that connected to a local DB server(SQL server) . 1-Web app that connected to a remotre server(SQL server). 1-Mobile app for that connected to tha same remote server of the web app. The Details: 1-The win app deals with a DB(Local DB SQL server) for updating ,retriving,inserting and deleting. 2-The web & the mobile app deal with a DB(Remote DB SQL server) for tha same purpose.(updating ,retriving,inserting and deleting) The Goal: 1-The Win app will connect one time per day to update the Remote SQL server with the new data from the Local SQL server. 2-The Web and mobile app connected to the Remote SQL server will update ,retrieve ,delete and insert records in it. The Questions: 1-If I can use Asp.net web services ,How can I use it? 2-How can i make daily transaction to update the Remote SQL server with the new data at the Local SQL server?? 3-How can i make daily transaction to update the Local SQL server with the new data at Remote SQL server ?? 4-How can i manage the DB Transactions ? 5-how can i use the same methods(code) for dealing with the DB ,for the win app , the web app and the mobile app? 5-What is the best way to complete this solution? Thanks for reading to this line. I hope you can help me. thanks again. Best Regards Ahmed Gaser FCSIS IS Dept.
Not much difference between the two, I am assuming you may not know how to get to the remote server. Use three config keys in your web.config file. Define the regular server name for the local server and use the IP addresses of the remote server. You can also set the servers up as linked servers and then one can talk to the other. I believe you could look into subscription service as well. As for using the same classes you can by compiling a separate dll and importing it into all three apps. Keep the class limited to only returning data or manipulating data and you should be fine. At the application level check to see which application you are using or set a constant that you use when obtaining the data source name. Hope I understood the question and that this helps. I need a break anyway. Pamela Reinskou VersusLaw Inc.