Jul 13, 2010 - SQL Server Compact Edition 3.5 can be used to create applications that. By applying SP2 the installed version on the machine is upgraded to. Finally got SQL Server Compact Edition 4.0 working under IIS 7.5. In case, they are not, then install Compact SP2 x86 and x64 MSIs from following link as.

This blog post covers some of the issues that can be encountered when using SQL Server Compact under ASP.NET, in particular in a hosted environment, where the environment can be restricted in unexpected ways. In order to be able to troubleshoot issues with ASP.NET hosting of web sites using SQL Server Compact 4.0, it can be useful to understand how Medium Trust works. Medium Trust only works under.NET 4.0 (ASP.NET 4.0), as it depends on a configuration in the global web.config.

The global web.config is located at C: Windows Microsoft.NET Framework v4.0.30319 Config or C: Windows Microsoft.NET Framework64 v4.0.30319 Config, and contains the following setting, that was configured when.NET 4.0 was installed: So this was added during installation of.NET 4.0, long before SQL Server Compact 4.0 was released in January 2011. The fullTrustAssemblies element is new in.NET 4.0: If this section has been removed from the global web.config file, SQL Server Compact 4.0 will not run under medium trust.

After more than 66.000 downloads, version 2.5 of my extension for Visual Studio 2010 is now. This blog post is a visual guide to the new features included in this release, many suggested by users of the tool via the Properties of selected Database and Table displayed in Properties window When you navigate the list of SQL Server Compact databases and database objects, the Toolbox now displays properties for a Database and a Table. Itr v acknowledgement ay 2013 14 excel format.

The Database properties are the following: And the table properties are these: DGML file (database graph) now also contains object descriptions The database graph (DGML) file has been enhanced to display descriptions of Database, Table and Column objects, based on the documentation feature introduced in version 2.3: Entity Data Model dialog now allows adding configuration for Private Desktop Deployment to app.config When using Entity Framework with Private Deployment of SQL Server Compact, some entries in app.config are required (for Desktop application), as described. This is required, as Entity Framework build in the DbProvider interfaces, which requires some configuration entries. These settings can now be added when creating an EDM as shown below: Ability to add 3.5 Connections from Toolbox It is now possible to add 3.5 Database Connections to the Server Explorer and the Toolbox directly from the Toolbox, rather than having to go to Server Explorer, add the connection, and then Refresh the Toolbox. You can now do this without leaving the Toolbox, and the Toolbox will refresh “automagically”. Improved VS UI Guidelines compliance The Toolbars, SQL Editor Font, Dialogs (frame, background and buttons) have been overhauled to comply better with my recent discovery of “Visual Studio UI Guidelines”, available for download. In addition, the Toolbox now follows the chosen Visual Studio Theme (to some extent, anyway). This is the “new look” for the Toolbox Explorer and SQL Editor: Other minor improvements and fixes - Explorer Treeview: ArgumentException when getting connections - WinPhone DataContext: Split files failed with empty database - SQL editor: Check if.sqlplan is supported - SQL editor: Save button was not working - SQL editor: Results pane not always cleared - SQL editor: Results as text improved formatting - SQL editor: Text scrollbar was overlaid by splitter bar As usual, the full source code for these new features is available on CodePlex for you to re-use or maybe improve!

A major update to SQL Server Compact 3.5 SP2 has just been released, version 3.5.8088.0, disguised as a “Cumulative Update Package”. Microsoft knowledgebase article describes the update. The update contains updated Server Tools, and updated desktop and device runtimes, all updated to support Merge Replication with the next version of SQL Server, SQL Server 2012. For a complete list of Cumulative Updates released for SQL Server Compact 3.5 SP2, see my It is nice to see that the 3.5 SP2 product, with it’s full range of device support and synchronization technologies is kept alive and kicking. NOTE: I this update earlier, but it was pulled back.

Now it is finally available, and all downloads can be requested. (I have downloaded all the ENU ones, anyway). This is an attempt at a comprehensive list of SQL Server Compact 3rd party tools, both commercial and non-commercial. Please let me know if I have missed anything, and I will add it. Just to summarize, the current Microsoft supplied tools are the following: Visual Studio 2010 (3.5 SP2) Visual Studio 2010 SP1 + 4.0 Tools (3.5 SP2 + 4.0) WebMatrix (4.0) New or updated entries are noted with (new) or (updated) ”Last updated” indicates when the tool was last updated by it’s author. It may sometimes by useful to be able to see the SQL statements generated by an ORM, in order to understand better what is going on, and why things perform the way they do. With LINQ to SQL on desktop, you can assign any TextWriter object to the DataContext Log property, and this will allow you to log to a file or the console.