RE: Create SDF from DBML ???

Hi Jakob,

I think the reason why we cannot create the SDF file with the current .dbml
file is because of the non-support of data table schema in SQLCE.
By default, the data table in SQL Server is under schema dbo. We can see
an attribute on each data table data class like:
========================================================
[Table(Name="dbo.TableName")]
========================================================

Please try to remove the schema name in the dbml designer file and run some
code snippet as the following to create such a SDF file:
========================================================
string cs = @"Data Source='c:\data.sdf'";
using (SqlCeConnection conn = new SqlCeConnection(cs))
{
    MyDataContext db = new MyDataContext (conn);
    db.CreateDatabase();
}
========================================================

If the SDF is created successfully, we can use the modified .dbml file to
connect the SDF file, please remember to pass a SqlCeConnection to the
DataContext.

For how to synchronize the data from the client SQLCE to the remote SQL
Server, Remote Data Access (RDA) and Merge Replication features of SQLCE
can be really helpful. For detail, please see
http://msdn.microsoft.com/en-us/library/ms172917.aspx
http://msdn.microsoft.com/en-us/library/ms172367.aspx

Hope you have a nice day!

Best Regards,
Lingzhi Sun
Microsoft Online Community Support

=================================================
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@microsoft.com.

This posting is provided "AS IS" with no warranties, and confers no rights.
=================================================