Proper way to structure a Sync Framework DAL

Question

I am creating a WPF app that needs to allow users to work in a temporary disconnected state and I plan to use a Local Database Cache.

My question's are about my data access layer.

• Do you typically create the whole DAL to point at the Cache or both and create a switching mechanism?

• Is Entity's a good way to go for my DAL against the Cache?

• I am used to L2S but my understanding is that I can't use that against SQLCE, correct?

Thanks!

PS: Any good resources out there for using Sync, Linq, and WPF ALL TOGETHER? Tutorials, videos, etc?

Answer 1

You might want to look at this blog post: http://blogs.msdn.com/matt/archive/2008/09/09/sql-ce-3-5-with-linq-to-sql.aspx

Answer 2

You might be interested in the Microsoft Sync Framework or at least some of the resources and examples.