private Result InternalExecute(object[] source) { var r = Result.OK; if (!Prepared) { Statement = Prepare(); Prepared = true; } //bind the values. if (source != null) { for (int i = 0; i < source.Length; i++) { BindParameter(Statement, i + 1, source[i], Connection.StoreDateTimeAsTicks); } } r = SQLite3.Step(Statement); if (r == Result.Done || r == Result.OK || r == Result.Row) { return(r); } else { var msg = SQLite3.GetErrorMessageUTF8(Connection.Handle); if ((ExtendedResult)r == ExtendedResult.ConstraintNotNull) { throw new NotNullConstraintViolationException(r, msg, sql: CommandText); } if ((ExtendedResult)r == ExtendedResult.ConstraintUnique) { throw new UniqueConstraintViolationException(r, msg, sql: CommandText); } throw new SQLiteException(r, msg, sql: CommandText); } }
public IEnumerable <T> ExecuteQuery <T>(TableMapping map, object[] source) { CheckDisposed(); Log(nameof(ExecuteQuery), source); OnExecutionStarted(); var sw = Stopwatch.StartNew(); try { var r = Result.OK; if (!Prepared) { Statement = Prepare(); Prepared = true; } //bind the values. if (source != null) { for (int i = 0; i < source.Length; i++) { BindParameter(Statement, i + 1, source[i], Connection.StoreDateTimeAsTicks); } } var cols = new TableColumn[SQLite3.ColumnCount(Statement)]; for (int i = 0; i < cols.Length; i++) { var name = SQLite3.ColumnNameUTF8(Statement, i); cols[i] = map.FindColumn(name); } while (SQLite3.Step(Statement) == Result.Row) { var obj = map.CreateInstance(); for (int i = 0; i < cols.Length; i++) { if (cols[i] == null) { continue; } var colType = SQLite3.ColumnType(Statement, i); var val = ReadCol(Statement, i, colType, cols[i].ColumnType, cols[i].PropertyDefaultValue); cols[i].SetValue(obj, val); } OnInstanceCreated(obj); yield return((T)obj); } if (r == Result.Done || r == Result.OK) { } else { var msg = SQLite3.GetErrorMessageUTF8(Connection.Handle); var ex = new SQLiteException(r, msg, sql: CommandText); ex.PopulateColumnFromTableMapping(map); throw ex; } } finally { if (Statement != null) { SQLite3.Reset(Statement); } sw.Stop(); Log(sw); OnExecutionEnded(); } }