SqlDbType.VarChar not valid type in sql compact

• Question

• 

  

  0

  Sign in to vote

  why is it that everytime a minor change is done to a dataset that is strongly typed to a sqlserverce data source that it changes all the sqlceparameters to "varchar", when it isn't a valid datatype in sql compact?  I converted my existing dataset (running agains sql server) to everything sqlserverce (parameters, connections, etc.).   i did this because there are a lot of queries i didn't want to have to copy over.

  Also, it seems to love putting [dbo].[tablename] all over the place, where [dbo] is also not valid for sql compact.

  When i created a brand new dataset, and added the tables from the .sdf file, it doesn't seem to do this, but i cant figure out why.

  thanks

  ---

  ~george

  Thursday, September 20, 2012 6:22 PM