Web Parts and SQL CE
I have tried and failed to include a simple Web Parts sample for ASP.NET Web Forms Basics and Esoterics in my studio. The error is:
Exception information:
Exception type: SqlException
Exception message: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)It concerns me that `System.Data.SqlClient` is in use here instead of `System.Data.SqlServerCe.4.0`, which is specified in the connection string. This setting comes from installing the NuGet package, `System.Web.Providers` based on Scott Hanselman’s “[Introducing System.Web.Providers—ASP.NET Universal Providers for Session, Membership, Roles and User Profile on SQL Compact and SQL Azure](http://www.hanselman.com/blog/IntroducingSystemWebProvidersASPNETUniversalProvidersForSessionMembershipRolesAndUserProfileOnSQLCompactAndSQLAzure.aspx).” I have yet to find an article about using Web Parts with SQL CE.