I realize in advance that is is a difficult task but would like to get the request in early so it can be considered for planning. This does have the potential to get overly complex if we tried to make it a completely automatic sync framework. But I think there is probably a sweet spot where we provide patterns/guidance and a set of useful APIs that make it very easy to setup online/offline sync. A lot of the complexity in a full blown sync framework comes from having to deal with every possible case.
Home Windows 10 Windows 10 Mobile Previous versions MDOP Surface Surface Hub Library Forums. Value of “Last Database Log Backup” of second DB in SQL Server Management Studio is “None”. I don’t understand why DPM does not sync with second DB even though settings are identical for both DBs. Edited by Darth Vader Monday. Also, those servers have no direct connection. How can I sync both back-end databases to keep the database data up to date? These details may be useful: It's a big amount of data - about 25,750 client records. You are writing data to the DB. Externally modifying then re-importing data with MS Access.
But if you know how your data 'behaves' then it quickly becomes a lot simpler. This is somewhat similar to our attempt to solve the N-Tier change tracking problem with self-tracking entities (did not go well ?). But with our new TrackGraph API we are making progress towards having the right building blocks to easily solve the problem (though we are not quite there yet). There was a time when I would have agreed but the world is evolving in unexpected ways. EF was developed as an Object Relational Mapper. To mitigate the mismatch between object oriented code and relational databases.
Yet EF Core is to support Cosmos DB. A non-relational database. So the purpose of EF Core has changed, from ORM to a tool to facilitate data access.To quotewe are making progress towards having the right building blocks to easily solve the problemThat was Feb 2016. There is huge demand for data driven partially disconnected apps, so if EF Core can facilitate that, why not? Who is better placed? Looks like that repo is interacting directly with the DB.I'm looking for interaction of client with an ASP.NET Core Web API server that uses EF. I'm working on a synchronization framework that can be used with EF Core.
Unlike the libraries mentioned above, mine uses deltas. Changes are sent among client and server in the format - actually, of it.Although as a feature it's out of EF Core's scope, this issue should remain open as a goal. We can continue discussing how to facilitate the occasionally-connected mobile app scenario.
For one benefit, this issue provides context as to why I want fixed.Since this is my current focus, I'd love to discuss my approach to synchronization, and the overall occasionally-connected mobile app scenario, with whoever's interested. Reply here or email me to continue the conversation. Since most apps need this, I would have expected solutions to be available. It's disappointing that Microsoft is no longer actively developing its sync technologies: Sync Framework and Azure Mobile Apps.I am considering EF and it appears that using EF core code-first (rather than managing database tables directly) will actually make sync harder, since we will want to use all the tables as they are in the database (with ids instead of objects) in order to sync. Please correct me if I'm wrong here.