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.
Got something to say?