SqlDbType.VarChar not valid type in sql compact RRS feed

  • Question

  • 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.



    Thursday, September 20, 2012 6:22 PM

All replies

  • you should consider posting your question to the SQL Compact forum. This is the Sync Framework Developer forum and your question is no longer specific to sync framework but refer to development question on .NET/VS/SqlCompact
    Friday, September 21, 2012 2:16 AM