Hi,
I am writing a repository class which is returning EntityCollection's, and I want to test my code out with a mocked out repository, so that I don't have any unpleasant brittle dependencies on the database.
The way i do this usually is to mock the repository and in my mocks, return a hand coded entity collection for the tests. However, some of my graphs are quite deep now, and this is getting pretty tedious. So, I was thinking that a nice alternative would be to use a "local" SQL Server Compact Edition database complete with the same tables and some test data, and in my test project set the connection string to this database file.
The LLBLGen gen'd code is fed from a SQL Server 2005 database, so before i spend a lot of time setting up a SQL Server CE "mini" database, I wanted to check if this is going to work, or if it will fail because I need to re-generate the code off the SQL Server CE database using different settings....
Thanks
Matt