Plugin Trouble

I am creating a plugin that has a set of tables that it adds into the database

and when using Compact Edition I get this error when those tables are trying to be created

There was an error parsing the query. [ Token line number = 12,Token line offset = 1,Token in error = CREATE ]

But it works fine using standard SQL server. Why? The tables do have navigation properties could that be it?

Hi dswatik,

There is a known issue executing a single query containing multiple statements in Compact Edition.
If you create a single table in the database it will work fine but if you try to create more than one tables for example it won't work.
The workaround for this is to separate your query into several queries and execute them one after another.
A little bit stupid as you loose the automatic sql code generation in Compact Edition.
You might also try to split your automatically generated query and then in a simple foreach to execute each statement separately.

Hope this helps!