in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

1.0.52.0 Posted

Last post 07-16-2008 4:56 PM by Robert Simpson. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 07-16-2008 4:56 PM

    1.0.52.0 Posted

    • Code merge with SQLite 3.6.0
    • Added a lot of previously-missing exports to the DEF file for the native library.
    • Fixed SQLiteDataReader to check for an invalid connection before operating on an open cursor.
    • Implemented the Cancel() function of SQLiteCommand to cancel an active reader.
    • Added beta table and view designers to the Visual Studio Server Explorer.  You can now edit/create tables and views, manage indexes and foreign keys from Visual Studio.  This feature is still undergoing testing so use at your own risk!
    • Fixed the Server Explorer so VS2005 users can once again right-click tables and views and open the table data.
    • Added some new interop code to assist in returning more metadata not normally available through the SQLite API.  Specifically, index column sort modes and collating sequences.  Also added code to detect (but not parse) CHECK constraints, so the table designer can pop up a warning when editing a table with these constraints.  Since I can't currently parse them.
    • Lots of LINQ SQL generation improvements and fixes.
    • Made some progress cleaning up and fixing up the schema definitions and manifests for EdmGen.
    • Added a built-in SQLiteFunction called last_rows_affected() which can be called from SQL to get the number of rows affected by the last update/insert operation on the connection.  This is roughly equivalent to Sql Server's @@ROWCOUNT variable.
Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems