none
Is/will there be support for SQL Server Compact in Visual Studio 2013?

    Question

  • I'm testing Visual Studio 2013 and when I try to open an xsd file I get the following error:

    "The Dataset Designer in this version of Visual Studio is not compatible with SQL Server Compact connections"

    Will SQL Server Compact be supported in the final release?

    Monday, October 07, 2013 1:46 PM

Answers

  • The DDEX provider for SQL Server Compact is not included with VS 2013, but you can install my SQL Server Compact Toolbox add-in and access both 3.5 and 4.0 files directly in the GUI.

    Why are you using DataSet, it is not recommended approach with SQL Server Compact, due to double buffering overhead, use SqlCeResultSet or even LINQ to SQL, the Toolbox can help you with that.


    Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com

    Monday, October 07, 2013 4:43 PM

All replies

  • The DDEX provider for SQL Server Compact is not included with VS 2013, but you can install my SQL Server Compact Toolbox add-in and access both 3.5 and 4.0 files directly in the GUI.

    Why are you using DataSet, it is not recommended approach with SQL Server Compact, due to double buffering overhead, use SqlCeResultSet or even LINQ to SQL, the Toolbox can help you with that.


    Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com

    Monday, October 07, 2013 4:43 PM
  • Thanks, good to know that we need to rewrite that part of our code before we move to VS2013.

    I'm glad you did not say that SQL Server CE was outdated and should not be used :)

    I had a look at the SQL Server Compact Toolbox and found the "script as ..." menu items which generated SQL queries.

    I assume you say I should use a SqlCeCommand to query the data in either a SqlCeDataSet or SqlCeDataReader format.

    The previously used DataSet Designer generated code for TableAdapters and custom row classes with typed propertied for each column, does the toolbox have features similar to that or is the way to go to use direct commands such as the ones below?

    (please disregard any crazy formatting below, no emphasis was intended)

    SqlCeCommand c = new SqlCeCommand("SELECT...", connection);
    c.Parameters.Add("cost", 45);
    var r = c.ExecuteReader();

    foreach (var row in r) { r.GetInt32(2); }



    Tuesday, October 08, 2013 8:15 AM
  • Yes, the Toolbox can generate a LINQ to SQL DataContext with strongly typed classes representing your tables, so you can get something similar to Typed dataSets. See my recent blog post for an intro to this: http://erikej.blogspot.dk/2013/10/sql-server-compact-4-desktop-app-with.html

    Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com


    Tuesday, October 08, 2013 9:08 AM
  • Pls feel free to contact me by email, I may have found a way to re-enable the DDEX provider (Server Explorer Data Source)

    Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com

    Thursday, October 10, 2013 11:16 AM