Derik Whittaker



SqlCeException–The specified table does not exist. [ TABLENAMEHERE ]–WP7 Mango

If you are new to SQL Ce, like I am, and you are using it on WP7 Mango you MAY run across the following error:

SqlCeExeption – The Specified Table does not exist [TableNameGoesHere]

I know that I ran into this the VERY first time I tried to create any type of database schema.  If you are like me the first thing you did was double check to ensure that your table mapping attributes were setup correctly (mine were).  If you are also like me you stared at your code for like 10 minutes asking WTF MAN its all right…

Turns out the solution to this is that you need to make sure that you have an Table<Entity> field setup on the data context which is being used.  By adding the following line to my DataContext class the error went away.

public Table<EpisodeTag> EpisodeTags;

Give this a check, ensure that you have a field for EVERY one of the tables which you are using, if you don’t that may be your issue. 

Hope this helps,

Till next time,

Posted 07-20-2011 4:39 PM by Derik Whittaker
Filed under: ,



Derik Whittaker wrote Using SQL CE on WP7 Mango–Getting Started
on 07-21-2011 5:52 PM

One of the major new ‘features’ of WP7 Mango is the addition of SQL CE 3.5 support.  Prior to Mango

Derik Whittaker wrote Using SQL CE On WP7 Mango–Working with Associations
on 07-23-2011 2:20 PM

In my previous post I took a step by step look at how to get up and running using SQL CE inside of your

About The CodeBetter.Com Blog Network
CodeBetter.Com FAQ

Our Mission

Advertisers should contact Brendan

Google Reader or Homepage Latest Items
Add to My Yahoo!
Subscribe with Bloglines
Subscribe in NewsGator Online
Subscribe with myFeedster
Add to My AOL
Furl Latest Items
Subscribe in Rojo

Member Projects
DimeCasts.Net - Derik Whittaker

Friends of
Red-Gate Tools For SQL and .NET


SmartInspect .NET Logging
NGEDIT: ViEmu and Codekana
NHibernate Profiler
Balsamiq Mockups
JetBrains - ReSharper
Web Sequence Diagrams
Ducksboard<-- NEW Friend!


Site Copyright © 2007 CodeBetter.Com
Content Copyright Individual Bloggers


Community Server (Commercial Edition)