private void SaveOrUpdate <T>(ActionType actionType, string[] columns, object[] values) { Type entity = typeof(T); List <T> list = new List <T>(); string tableName = AttributeInfo.GetTableName(entity); try { using (var em = EntityManagerFactory.CreateInstance(dataSource)) { Query q = null; if (actionType == ActionType.Save) { q = new Query().Select(columns).From(tableName).Insert(values); } else { string id = values[0].ToString(); q = new Query().Select(columns).From(tableName).Update(values) .Where(GetQueryClause(em.DataSource, entity, id)); } string sql = q.ToSql(); em.ExecuteNonQuery(sql); } } catch (Exception ex) { throw new Exception(ex.ToString()); } }
public object ExecuteScalar(string sql) { using (var em = EntityManagerFactory.CreateInstance(dataSource)) { return(em.ExecuteScalar(sql)); } }
public void ExecuteNonQuery(string sql) { using (var em = EntityManagerFactory.CreateInstance(dataSource)) { em.ExecuteNonQuery(sql); } }
public IDataReader ExecuteReader(string sql) { IDataReader rdr = null; var em = EntityManagerFactory.CreateInstance(dataSource); rdr = em.ExecuteReader(sql); return(rdr); }
public List <T> GetByQuery <T>(string sql) { List <T> list = new List <T>(); try { using (var em = EntityManagerFactory.CreateInstance(dataSource)) { list = em.ExecuteList <T>(sql); } } catch (Exception ex) { throw new Exception(ex.ToString()); } return(list); }
public void Delete <T, P>(P id) { Type entity = typeof(T); string tableName = AttributeInfo.GetTableName(entity); try { using (var em = EntityManagerFactory.CreateInstance(dataSource)) { var q = new Query().From(tableName).Delete().Where(GetQueryClause(em.DataSource, entity, id)); string sql = q.ToSql().Substring(6); em.ExecuteNonQuery(sql); } } catch (Exception ex) { throw new Exception(ex.ToString()); } }
public List <T> GetAll <T>(string orderClause) { Type entity = typeof(T); List <T> list = new List <T>(); string tableName = AttributeInfo.GetTableName(entity); try { using (var em = EntityManagerFactory.CreateInstance(dataSource)) { string sql = "SELECT * FROM " + tableName + " " + orderClause; list = em.ExecuteList <T>(sql); } } catch (Exception ex) { throw new Exception(ex.ToString()); } return(list); }
public T GetById <T, P>(P id) { Type entity = typeof(T); T obj = default(T); string tableName = AttributeInfo.GetTableName(entity); try { using (var em = EntityManagerFactory.CreateInstance(dataSource)) { string sql = "SELECT * FROM " + tableName + " WHERE " + GetQueryClause(em.DataSource, entity, id); obj = em.ExecuteObject <T>(sql); } } catch (Exception ex) { throw new Exception(ex.ToString()); } return(obj); }