public static NotNullConstraintViolationException New(SQLiteException exception, TableMapping mapping,
object obj)
{
return(new NotNullConstraintViolationException(exception.Result, exception.Message, mapping, obj));
}
protected NotNullConstraintViolationException(SQLite3.Result r, string message, TableMapping mapping,
object obj) : base(r, message)
{
if (mapping != null && obj != null)
{
this.Columns = from c in mapping.Columns
where c.IsNullable == false && c.GetValue(obj) == null
select c;
}
}
public static NotNullConstraintViolationException New(SQLite3.Result r, string message, TableMapping mapping,
object obj)
{
return(new NotNullConstraintViolationException(r, message, mapping, obj));
}
private TableQuery(SQLiteConnection conn, TableMapping table)
{
this.Connection = conn;
this.Table = table;
}
public TableQuery(SQLiteConnection conn)
{
this.Connection = conn;
this.Table = this.Connection.GetMapping(typeof(T));
}
public List <T> ExecuteQuery <T>(TableMapping map)
{
return(ExecuteDeferredQuery <T>(map).ToList());
}
public object Find(object pk, TableMapping map)
{
return(Query(map, map.GetByPrimaryKeySQL, pk).FirstOrDefault());
}
public T Find <T>(object pk) where T : new()
{
TableMapping map = GetMapping(typeof(T));
return(Query <T>(map.GetByPrimaryKeySQL, pk).FirstOrDefault());
}
public IEnumerable <object> DeferredQuery(TableMapping map, string query, params object[] args)
{
SQLiteCommand cmd = CreateCommand(query, args);
return(cmd.ExecuteDeferredQuery <object>(map));
}
public List <object> Query(TableMapping map, string query, params object[] args)
{
SQLiteCommand cmd = CreateCommand(query, args);
return(cmd.ExecuteQuery <object>(map));
}