SQL Server CE and Typed Datasets

I found out the hard way in the last two days that an SQL Server CE database does not work properly when creating a typed Dataset with a ASP.NET 3.5 application. Sure, you can create one in the IDE, but the code-on-the-fly will not be generated therefor you can’t use it in your code. Actually causes an error if you try to build.

Rec’d an confirmation from Microsoft today that they did not implement this for ASP.NET. Just wanted to warn you so you don’t waste an hour plus like I did. If you still want to use SQL Server CE and typed DataSets in ASP.NET you will need to create a separate assembly (which should be done anyway). Oh, won’t work with LINQ either.