public bool Execute <T>(string sql, IList <Parameter> parameters = null, int timeout = 15) where T : class, new() { using (IOrm orm = this.orm) { return(orm.Execute(new SqlCommand(sql, parameters, timeout))); } }
public Database(IDbConnection dbConnection, IOrm orm) { Check.Argument.IsNotNull(dbConnection, "dbConnection"); this.dbConnection = dbConnection; Check.Argument.IsNotNull(orm, "dataAccessConnection"); this.orm = orm; }
public bool Execute(IList <SqlCommand> unitOfWorks) { using (IOrm connection = this.orm) { return(connection.Execute(unitOfWorks)); } }
public IList <T> Select <T>(string sql, IList <Parameter> parameters = null, int timeout = 15) where T : class, new() { using (IOrm orm = this.orm) { return(orm.Select <T>(new SqlCommand(sql, parameters, timeout), CustomMapper.Resolve <T>()).ToList()); } }
public IList <T> Select <T>(Expression <Func <T, bool> > expression, int timeout = 15) where T : class, new() { using (IOrm orm = this.orm) { SqlCommand result = DynamicQuery.GetDynamicQuery(typeof(T).Name.ToLowerInvariant().Pluralize(), expression); return(orm.Select <T>(new SqlCommand(result.Statement, result.Parameters, timeout)).ToList()); } }
public async Task <bool> ExecuteAsync <T>(string sql, IList <Parameter> parameters = null, int timeout = 15) where T : class, new() { var result = false; using (IOrm orm = this.orm) { result = await orm.ExecuteAsync(new SqlCommand(sql, parameters, timeout)); } return(result); }
public async Task <bool> ExecuteAsync(IList <SqlCommand> unitOfWorks) { var result = false; using (IOrm orm = this.orm) { result = await orm.ExecuteAsync(unitOfWorks); } return(result); }
public bool Insert <T>(T entity, int timeout) where T : class, new() { if (entity != null) { SqlCommand queryResult = DynamicQuery.GetInsertQuery(typeof(T).Name.ToLowerInvariant().Pluralize(), entity); using (IOrm orm = this.orm) { return(orm.Execute(new SqlCommand(queryResult.Statement, queryResult.Parameters, timeout))); } } return(false); }
public async Task <bool> InsertAsync <T>(T entity, int timeout = 15) where T : class, new() { var result = false; if (entity != null) { SqlCommand queryResult = DynamicQuery.GetInsertQuery(typeof(T).Name.ToLowerInvariant().Pluralize(), entity); using (IOrm orm = this.orm) { result = await orm.ExecuteAsync(new SqlCommand(queryResult.Statement, queryResult.Parameters, timeout)); } } return(result); }
public async Task <IList <T> > SelectAsync <T>(string sql, IList <Parameter> parameters = null, int timeout = 15) where T : class, new() { IEnumerable <T> result = null; using (IOrm orm = this.orm) { result = await orm.SelectAsync <T>(new SqlCommand(sql, parameters, timeout), CustomMapper.Resolve <T>()); } if (result == null) { return(null); } return(result.ToList()); }
static void Main(string[] args) { string connectionstring = "Data Source=.\\SQLEXPRESS;uid=sa;pwd=root;Initial Catalog=test;Integrated Security=SSPI;Integrated Security=True"; IOrm orm = OrmFactory.GetOrm(ServerType.SqlServer, connectionstring); IOrm <User> torm = OrmFactory.GetOrm <User>(ServerType.SqlServer, connectionstring); string sql = "SELECT top 1000 dc.collection_id,dc.collection_name FROM data_collection dc "; //string mysql = "SELECT dc.collection_id,dc.collection_name FROM data_collection dc LIMIT 0,1000"; /*===========================================================================================*/ Stopwatch s = new Stopwatch(); s.Start(); //DataSet ds= MySqlHelper.ExecuteDataset(con, sql); //s.Stop(); //Console.WriteLine(ds.Tables[0].Rows.Count+"条,MySqlHelper DataSet:" + s.ElapsedMilliseconds); /*===========================================================================================*/ s.Restart(); DataTable t = orm.SqlQuery(sql).ExcuteDataTable(); s.Stop(); Console.WriteLine(t.Rows.Count + "条,返回DataTable:" + s.ElapsedMilliseconds); /*===========================================================================================*/ s.Restart(); List <collection> list = orm.SqlQuery(sql).ToEntityList <collection>(); s.Stop(); Console.WriteLine(list.Count + "条,返回List:" + s.ElapsedMilliseconds); s.Restart(); /*===========================================================================================*/ List <collection> list2 = orm.SqlQuery(sql).ToEntityList <collection>(); s.Stop(); Console.WriteLine(list2.Count + "条,第二次List:" + s.ElapsedMilliseconds); /*===========================================================================================*/ //*更新*/ int count = torm.UpdateColumn("NickName", "TsOrm").Where("Uid=89480").Update(); //*更新*/ int count2 = torm.UpdateColumn("NickName", "TsOrm2").Where(x => x.Uid == 89480).Update(); //*更新*/ int count3 = torm.UpdateColumn(x => x.NickName, "TsOrm").Where(x => x.Uid == 89480).Update(); int ccc = count; int ccc2 = count2; int ccc3 = count3; Console.ReadKey(); }
public async Task <IList <T> > SelectAsync <T>(Expression <Func <T, bool> > expression, int timeout = 15) where T : class, new() { IEnumerable <T> result = null; using (IOrm orm = this.orm) { SqlCommand query = DynamicQuery.GetDynamicQuery(typeof(T).Name.ToLowerInvariant().Pluralize(), expression); result = await orm.SelectAsync <T>(new SqlCommand(query.Statement, query.Parameters, timeout)); } if (result == null) { return(null); } return(result.ToList()); }
public static void Main(string[] args) { IOrm orm = null; IDynamodbClient dynamodbClient = null; IProductRepository productRepo = new ProductDatabaseRepository(orm); ICustomerRepository customerRepo = new CustomerDatabaseRepository(orm); Product p1 = productRepo.GetById(3); Customer c1 = customerRepo.GetById(49); productRepo = new ProductDynamodbRepository(dynamodbClient); customerRepo = new CustomerDynamodbRepository(dynamodbClient); p1 = productRepo.GetById(3); c1 = customerRepo.GetById(49); Console.WriteLine("Hello World"); }
/// <summary> /// 缓存实例,同步信息实例,编译器实例,ORM信息实例 /// </summary> /// <param name="orm"></param> public Transaction(IOrm orm) { Orm = orm; }
public DatabaseRepositoryBase(IOrm orm, string tableName, string primaryKey) { _orm = orm; _tableName = tableName; _primaryKey = primaryKey; }
public ProductDatabaseRepository(IOrm orm) : base(orm, "product", "id") { }
public CustomerDatabaseRepository(IOrm orm) : base(orm, "customer", "id") { }
/// <summary> /// Orm实例 /// </summary> /// <param name="orm"></param> /// <param name="executor"></param> public Key(IOrm orm, IExecutor executor) { Orm = orm; Executor = executor; }