Can’t get sql server compact 3.5 / 4 to work with ASP .NET MVC 2

by

SQL CE 3.5 does not work with ASP.NET, you must use 4.0 CTP.

Download from here.

Install the runtime.

Copy the following directory contents (including the x86 and amd64 folders) to the bin folder of your ASP.NET app:
C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\Private

UPDATE: Use System.Data.SqlServerCe.dll from the Desktop folder to avoid Medium Trust issues

myapp\bin\ 
 System.Data.SqlServerCe.dll 

myapp\bin\x86 
 sqlceca40.dll 
 sqlcecompact40.dll 
 sqlceer40EN.dll 
 sqlceme40.dll 
 sqlceqp40.dll 
 sqlcese40.dll 

myapp\bin\amd64 
 sqlceca40.dll 
 sqlcecompact40.dll 
 sqlceer40EN.dll 
 sqlceme40.dll 
 sqlceqp40.dll 
 sqlcese40.dll

Add a reference to the System.Data.SqlServerCe.dll file you just put in your /bin folder.

Place the SQL Compact sdf file in your App_Data folder.

Add connection string:

<connectionStrings>
   <add name ="NorthWind"
   connectionString="data source=|DataDirectory|\Nw40.sdf" />
</connectionStrings>

Connect! 🙂

using System.Data.SqlServerCe;

    protected void Page_Load(object sender, EventArgs e)
    {
        using (SqlCeConnection conn = new SqlCeConnection())
        {
            conn.ConnectionString = ConfigurationManager.ConnectionStrings["Northwind"].ConnectionString;
            conn.Open();
            using (SqlCeCommand cmd = new SqlCeCommand("SELECT TOP (1) [Category Name] FROM Categories", conn))
            {
                string valueFromDb = (string)cmd.ExecuteScalar();
                Response.Write(string.Format("{0} Time {1}", valueFromDb, DateTime.Now.ToLongTimeString()));
            }
        }
    }

More Related Contents:

  1. How to write a simple Html.DropDownListFor()?
  2. Making a Simple Ajax call to controller in asp.net mvc
  3. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  4. How to implement reCaptcha for ASP.NET MVC? [closed]
  5. When using .net MVC RadioButtonFor(), how do you group so only one selection can be made?
  6. When `PostAuthenticateRequest` gets execute?
  7. How can I convert ticks to a date format?
  8. Cannot find namespace ‘System.Data.SqlServerCe’
  9. Validating for large files upon Upload
  10. How can I strip HTML tags from a string in ASP.NET?
  11. How to force HTTPS using a web.config file
  12. Could not find a part of the path … bin\roslyn\csc.exe
  13. How to update a claim in ASP.NET Identity?
  14. Why is HttpContext.Current null?
  15. How do I get the kestrel web server to listen to non-localhost requests?
  16. ASP.Net 2012 Unobtrusive Validation with jQuery
  17. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  18. ASP.NET MVC Razor render without encoding
  19. Images in dropdown list
  20. How do I read the current path of |DataDirectory| from config settings
  21. Error – is not marked as serializable
  22. How can I handle forms authentication timeout exceptions in ASP.NET?
  23. How can I get the baseurl of site?
  24. How do I force full post-back from a button within an UpdatePanel?
  25. How require authorization within whole ASP .NET MVC application
  26. What is the difference between Debug Mode and Release Mode in Visual Studio 2010? [duplicate]
  27. Accessing controls created dynamically (c#)
  28. Could not load file or assembly ‘System.Net.Http.Formatting’ or one of its dependencies. The system cannot find the path specified
  29. Why does ServerVariable[“REMOTE_ADDR”] returns the server IP?
  30. IIS Request.UserHostAddress returning IPV6 (::1), even when IPV6 disabled

Leave a Comment