public IEnumerable <T> SqlQueryScalars <T>(string sql, object parameters = null) where T : new() { if (DataProvider is ISqlDataProvider sqlProvider) { return(sqlProvider.SqlQueryScalar(sql, QueryParameterCollection.FromObject(parameters)).Select(scalar => scalar.Convert <T>())); } throw new NotSupportedException(); }
public T SqlQueryScalar <T>(string sql, object parameters = null) where T : new() { if (DataProvider is ISqlDataProvider sqlProvider) { return(sqlProvider.SqlQueryScalar(sql, QueryParameterCollection.FromObject(parameters)).FirstOrDefault().Convert <T>()); } throw new NotSupportedException(); }
public IEnumerable <Dictionary <string, object> > SqlQuery(string sql, object parameters = null) { if (DataProvider is ISqlDataProvider sqlProvider) { return(sqlProvider.SqlQuery(sql, QueryParameterCollection.FromObject(parameters)).Select(entity => entity.AsDictionary())); } throw new NotSupportedException(); }
public IEnumerable <T> SqlQuery <T>(string sql, object parameters = null) where T : new() { if (DataProvider is ISqlDataProvider sqlProvider) { return(sqlProvider.SqlQuery(sql, QueryParameterCollection.FromObject(parameters)).Select(entity => entity.CreateObject <T>())); } throw new NotSupportedException(); }
// Native SQL methods public int SqlNonQuery(string sql, object parameters = null) { if (DataProvider is ISqlDataProvider sqlProvider) { return(sqlProvider.SqlNonQuery(sql, QueryParameterCollection.FromObject(parameters))); } throw new NotSupportedException(); }
public override void Purge(TableSchema schema) { var tableName = SqlDialect.QuoteTable(schema.MappedName); ExecuteSql("DELETE FROM " + tableName, null); if (SqlQueryScalar("select name from sqlite_master where name='sqlite_sequence'", null).Any()) { ExecuteSql("delete from sqlite_sequence where name=@name", QueryParameterCollection.FromObject(new { name = schema.MappedName })); } }