SubSonic and MS SQL Server Compact - Data Provider

Question

I developing new application and I would like using SubSonic and SQL Server Compact.

But when I run my simple app (for trying SubSonic) I get exception "Unable to find the requested .Net Framework Data Provider. It may not be installed."

Anyone have some advice for me, how solve this?

I have reference to System.Data.SqlServerCe

---

UPDATE

I downloaded SubSonic latest source code and all code about SQL CE is in comments. I uncomment, but I get same exception.

• DbDataProvider.cs

Answer 1

EDIT: SQL Server CE is supported in SubSonic 2.2 but not in 3. See the docs for more details.

SQL Server CE is not supported at the moment. Someone is apparently working on it but I don't know how far the work on the template has progressed:

http://github.com/subsonic/SubSonic-3.0/issues/unreads#issue/17

Answer 2

@Adam, your comment is only for Subsonic 3.0, right? SQL Server CE is still supported in Subsonic 2.x?

Answer 3

I have the same problem with my MySQL provider. Not sure if i've missed something in my web.config but i'm getting error: "Unable to find the requested .Net Framework Data Provider. It may not be installed.".

I'm using subsonic3.0 and Asp.NET 3.5 MVC.

Got MySQL Connector/Net 6.2.3 dll in my references list in vwd2010, Libs/ folder on the filesystem.

Web.config:

<connectionStrings>
    <add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
    <add name="ob3" connectionString="server=localhost;database=obriefv3;user id=obrief; password=*****" providerName="MySqlDataProvider"/>
</connectionStrings>

<system.web>
    <compilation debug="true" targetFramework="4.0">
        <assemblies>
            <add assembly="System.Web.Mvc, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
            <add assembly="System.Web.Abstractions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
            <add assembly="System.Web.Routing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/></assemblies>
    </compilation>
    <authentication mode="Forms">
        <forms loginUrl="~/Account/LogOn" timeout="2880"/>
    </authentication>
    <membership>
        <providers>
            <clear/>
            <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="ApplicationServices" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" applicationName="/"/>
        </providers>
    </membership>
    <profile>
        <providers>
            <clear/>
            <add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="ApplicationServices" applicationName="/"/>
        </providers>
    </profile>
    <roleManager enabled="false">
        <providers>
            <clear/>
            <add name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider" connectionStringName="ApplicationServices" applicationName="/"/>
            <add name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" applicationName="/"/>
        </providers>
    </roleManager>
    <pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID">
        <namespaces>
            <add namespace="System.Web.Mvc"/>
            <add namespace="System.Web.Mvc.Ajax"/>
            <add namespace="System.Web.Mvc.Html"/>
            <add namespace="System.Web.Routing"/>
        </namespaces>
    </pages>
</system.web>
<system.webServer>
    <modules runAllManagedModulesForAllRequests="true">
    </modules>
    <handlers>
        <remove name="UrlRoutingHandler"/>
    </handlers></system.webServer>
<runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
        <dependentAssembly>
            <assemblyIdentity name="System.Web.Mvc" publicKeyToken="31bf3856ad364e35"/>
            <bindingRedirect oldVersion="1.0.0.0" newVersion="2.0.0.0"/>
        </dependentAssembly>
    </assemblyBinding>
</runtime>