SQLCE Error 26100: The table name is not valid

Posted on April 16, 2008

If you’re using LINQ to SQL with SQLCE and use the DataContext.CreateDatabase() method, you may encounter this error.  If you used the LINQ to SQL class designer to generate the classes from a different database provider (such as SQL Server 2005 or SQL Server Express), the table source names may be prefixed with “dbo.”

Just remove the prefix, and CreateDatabase() will succeed.

No Replies to "SQLCE Error 26100: The table name is not valid"

    Got something to say?

    Some html is OK