none
Refreshing data in client database table from server. RRS feed

  • Question

  • Here is my situation. I have client database structure that is same as what I have in server. I want to refresh (synchronize) data in the client, from server (for some of the tables). I will get the data using web service. I can delete all the data from tables and repopulate with the data that I get from server.  However, I am wondering is there a better approach of doing such operation using entity framework or ado.net in general?

    Thank you 

    Sunday, July 14, 2013 12:37 PM

Answers

  • Hi Patarya;

    I am assuming that you have a local database and a remote database and you wish to update / synchronize the data between the two. Entity Framework and as well as ADO .Net do not perform this functionality. SQL server or other products do have a functionality like this. If you do a web search for, local and remote SQL database synchronization, you will find what you are looking for.

    If this is not what you meant please post a new question in more detail of your desired results.

      


    Fernando (MCSD)

    If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".

    NOTE: If I ask for code, please provide something that I can drop directly into a project and run (including XAML), or an actual application project. I'm trying to help a lot of people, so I don't have time to figure out weird snippets with undefined objects and unknown namespaces.

    • Marked as answer by Patarya Monday, July 15, 2013 9:22 PM
    Sunday, July 14, 2013 2:03 PM

All replies

  • Hi Patarya;

    I am assuming that you have a local database and a remote database and you wish to update / synchronize the data between the two. Entity Framework and as well as ADO .Net do not perform this functionality. SQL server or other products do have a functionality like this. If you do a web search for, local and remote SQL database synchronization, you will find what you are looking for.

    If this is not what you meant please post a new question in more detail of your desired results.

      


    Fernando (MCSD)

    If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".

    NOTE: If I ask for code, please provide something that I can drop directly into a project and run (including XAML), or an actual application project. I'm trying to help a lot of people, so I don't have time to figure out weird snippets with undefined objects and unknown namespaces.

    • Marked as answer by Patarya Monday, July 15, 2013 9:22 PM
    Sunday, July 14, 2013 2:03 PM
  • Thank you for pointing me to the right direction. I am marking this as answer
    Monday, July 15, 2013 9:22 PM
  •  

    Not a problem, glad to help.

      


    Fernando (MCSD)

    If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".

    NOTE: If I ask for code, please provide something that I can drop directly into a project and run (including XAML), or an actual application project. I'm trying to help a lot of people, so I don't have time to figure out weird snippets with undefined objects and unknown namespaces.

    Monday, July 15, 2013 9:37 PM