/// <summary> /// Executes a query, returning the data typed as per T. /// </summary> /// <typeparam name="T">Result type.</typeparam> /// <param name="cnn">Connection.</param> /// <param name="sql">Sql.</param> /// <returns> /// A sequence of data of the supplied type; if a basic type (int, string, etc) is /// queried then the data from the first column in assumed, otherwise an instance /// is created per row, and a direct column-name===member-name mapping is assumed /// (case insensitive). /// </returns> public static List <T> Query <T>(this IDisposable cnn, BuildedSql sql) { //debug. Debug(sql); try { return(SQLiteNetPclWrapper <T> .GetQuery(cnn)(cnn, sql.Text, sql.GetParamValues())); } catch (Exception e) { throw GetCoreException(e); } }
/// <summary> /// Execute parameterized SQL. /// </summary> /// <param name="cnn">Connection.</param> /// <param name="sql">Sql.</param> /// <returns>Number of rows affected.</returns> public static int Execute(this IDisposable cnn, BuildedSql sql) { //debug. Debug(sql); try { return(SQLiteNetPclWrapper.GetExecute(cnn)(cnn, sql.Text, sql.GetParamValues())); } catch (Exception e) { throw GetCoreException(e); } }