Can you really export a sql server database (2008) to a different access database while using Entity framework (or other things for your matter in code)?

I've created a desktop facing application that connects to some sql sever on the server and my client really wants to have the ability to take pictures from the database in use of send to individuals who don't put on sql or accessibility sql server (because they can't get it done by hand).

This really is being completed in c# .Internet 3.5 SP1


It might be much simpler if you're able to convince the consumer to make use of SQL CE rather. You need to have the ability to create an adp database for the front-end from the SQL CE database. You should use Microsoft Sync Framework to sync data between databases.