making application workign without SQL Server by data migration ?

Question

I have to work on an desktop application with WinForms/ C#, SQL server and EF 4.

DAL has been implemented using Repository and UoW paterns. Data is being used just for read only purposes. Can you please adivce how Data base can be removed and application can be modified to work by using data from some files, XML or in memory collections.

Please guide how it can be done usign least changes.

Answer 1

There is no direct suport for EF to XML as data source. As you are using Repository you are some what safe do not need to change whole set of code. You need to write one more repository using LinqToXML which will map XML values to your POCO.

For actual CRUD using LinQ2XML refer: http://deepumi.wordpress.com/2010/03/08/linq-to-xml-crud-operations/ and http://www.dotnetcodecentral.com/Post/219/linq-to-xml/crud-operations-linq-to-xml-programming-c-sharp

---

Lingaraj Mishra