Jesse Johnston
.NET Dev. Good times with .NET and coffee

SQLCE Error 26100: The table name is not valid

Wednesday, 16 April 2008 00:05 by jesse

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.

kick it on DotNetKicks.com

Digg It!DZone It!StumbleUponTechnoratiRedditDel.icio.usNewsVineFurlBlinkList
Categories:   LINQ
Actions:   E-mail | del.icio.us | Permalink | Comments (0) | Comment RSSRSS comment feed
Comments are closed