Using Sql CE with a tool that uses dbo.TableName in the generated code

Question

I'm using SQL CE to test an application that will be deployed on SQL Server. (CE is very useful for that.)

I was originally using LinqToEntityFramework in the project but dropped that in favour of LinqToSQL (the older technology).

During test I'm getting Table does not exist exceptions because the generated code using the dbo.TableName syntax.

I can fix that in test by altering the generated code and everything just works.

I guess others have faced this issue.

What strategies work for you to use both CE and a production SQL Server database with the same code base?

Answer 1

Some forum threads with similar discussions:

http://social.microsoft.com/Forums/en-US/synctechnicaldiscussion/thread/22efedf2-282a-4178-a42f-dcb2515b4638

http://social.msdn.microsoft.com/Forums/en-US/sqlsmoanddmo/thread/6233de7b-21d6-4d93-a3aa-a165af79c540

http://blogs.msdn.com/stevelasker/archive/2007/03/31/creating-your-sql-server-compact-edition-database-and-schema-in-code.aspx

---

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

Answer 2

How do these links relate to the question?

(The last link appears to be broken, two tries.)

Answer 3

Hi Mike,

could you post some sample code with dbo.TableName - I thought that this was only in the dbml file, not in the generated classes?

---

http://erikej.blogspot.com Erik Ejlskov Jensen - Please mark as answer, if this was it.

Answer 4

Hi,

I'm busy on other projects at the moment.  I'll report back on this when I return to the project.