in

System.Data.SQLite

An open-source, enhanced version of the SQLite database engine for Windows

SQLiteCommandBuilder missing .DeriveParameters method

Last post 09-25-2007 6:50 AM by kevintownsend. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 09-20-2007 2:11 AM

    SQLiteCommandBuilder missing .DeriveParameters method

    The SQLiteCommandBuilder seems to be missing the static .DeriveParameters method (which is required for some operations that abstract the DB logic away from specific data providers).  Is there any chance of this method being implemented in the near future?  It's the sole reason I am not able to make use of the otherwise exceptional .net implementation of SQLite.

    Some examples are:

    SqlCommandBuilder.DeriveParameters

    OracleCommandBuilder.DeriveParameters

    OdbcCommandBuilder.DeriveParameters

     

  • 09-24-2007 9:02 PM In reply to

    Re: SQLiteCommandBuilder missing .DeriveParameters method

    Since SQLite doesn't support stored procedures, there's no point in implementing this function ... Case in point, if you attempt to execute DeriveParameters() on a SqlCommand that is not a stored procedure, you get this:

    SqlCommand DeriveParameters only supports CommandType.StoredProcedure, not CommandType.Text

    Now, if you'd like an empty function that just throws a Not Implemented error, then I can easily oblige ...

    Robert

     

     

  • 09-25-2007 6:50 AM In reply to

    Re: SQLiteCommandBuilder missing .DeriveParameters method

    I realized it will never be called, so I just throw a NotImplentedException in the appropriate place.  Sorry for the useless request.

Page 1 of 1 (3 items)
Powered by Community Server (Commercial Edition), by Telligent Systems