Derik Whittaker

Syndication

News


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: ,

[Advertisement]

Comments

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

Subscribe
Google Reader or Homepage

del.icio.us CodeBetter.com Latest Items
Add to My Yahoo!
Subscribe with Bloglines
Subscribe in NewsGator Online
Subscribe with myFeedster
Add to My AOL
Furl CodeBetter.com Latest Items
Subscribe in Rojo

Member Projects
DimeCasts.Net - Derik Whittaker

Friends of Devlicio.us
Red-Gate Tools For SQL and .NET

NDepend

SlickEdit
 
SmartInspect .NET Logging
NGEDIT: ViEmu and Codekana
LiteAccounting.Com
DevExpress
Fixx
NHibernate Profiler
Unfuddle
Balsamiq Mockups
Scrumy
JetBrains - ReSharper
Umbraco
NServiceBus
RavenDb
Web Sequence Diagrams
Ducksboard<-- NEW Friend!

 



Site Copyright © 2007 CodeBetter.Com
Content Copyright Individual Bloggers

 

Community Server (Commercial Edition)