/// <summary> /// .ctor /// </summary> /// <param name="dbProperty">数据库属性信息</param> /// <param name="isWrite">是否写连接(默认使用读连接)</param> public BaseDataAccess(DatabaseProperty dbProperty, bool isWrite = false) { EnsureUtil.NotNull(dbProperty, "dbProperty不能为空!"); DatabaseConnection dbConnection = isWrite ? dbProperty.Writer : dbProperty.Reader; _conn = CreateConnection(dbConnection); }
public static PropertyBase PropertyBase(DatabaseProperty propertyMetadata) { return(new PropertyBase() { Name = propertyMetadata.Name, Type = TypeBase(propertyMetadata.Type) }); }
public string GetChildDeclareId(DatabaseProperty property, string parameterName) { StringBuilder stringbuilder = new StringBuilder(); stringbuilder.AppendLine($"DECLARE @{property.SelectSqlParameterNaam} as bigint;"); stringbuilder.AppendLine($"SELECT @{property.SelectSqlParameterNaam} = {property.SelectSqlParameterNaam}"); stringbuilder.AppendLine($" FROM [dbo].{Entity.Name}"); stringbuilder.AppendLine($" WHERE {Entity.Name}.Id = {parameterName};"); return(stringbuilder.ToString()); }
/// <summary> /// .ctor /// </summary> /// <param name="dbProperty">数据库属性信息</param> /// <param name="isWrite">是否写连接(默认使用读连接)</param> public SqlDataAccess(DatabaseProperty dbProperty, bool isWrite = false) : base(dbProperty, isWrite) { }
public DescriptionHistoryColumnBuilder(DatabaseProperty property, Entity entity) : base(property, entity) { }
/// <summary> /// ִ���������XmlReader /// </summary> /// <param name="q">SqlQuery����</param> /// <param name="dp">Sql��������</param> /// <returns>XmlReader</returns> public static XmlReader ExecuteXmlReader(SqlQuery q, DatabaseProperty dp) { SqlDataAccess da = new SqlDataAccess(dp.ConnectionString); da.Open(); return da.ExecuteXmlReader(q); }
/// <summary> /// ִ���������Xml�ĵ� /// </summary> /// <param name="q">SqlQuery����</param> /// <param name="dp">Sql��������</param> /// <returns>Xml�ĵ�</returns> public static XmlDocument ExecuteXmlDoc(SqlQuery q, DatabaseProperty dp) { SqlDataAccess da = new SqlDataAccess(dp.ConnectionString); da.Open(); XmlDocument doc = da.ExecuteXmlDoc(q); da.Close(); return doc; }
/// <summary> /// ִ����������������е�Object /// </summary> /// <param name="q">SqlQuery����</param> /// <param name="dp">Sql��������</param> /// <returns>�������е�Object</returns> public static Object ExecuteScalar(SqlQuery q, DatabaseProperty dp) { SqlDataAccess da = new SqlDataAccess(dp.ConnectionString); da.Open(); object scalar = da.ExecuteScalar(q); da.Close(); return scalar; }
/// <summary> /// ִ���������Ӱ������ /// </summary> /// <param name="q">SqlQuery����</param> /// <param name="dp">Sql��������</param> /// <returns>Ӱ������</returns> public static int ExecuteNonQuery(SqlQuery q, DatabaseProperty dp) { SqlDataAccess da = new SqlDataAccess(dp.ConnectionString); da.Open(); int affectRows = da.ExecuteNonQuery(q); da.Close(); return affectRows; }
/// <summary> /// ִ���������Dataset /// </summary> /// <param name="q">SqlQuery����</param> /// <param name="dp">Sql��������</param> /// <returns>Dataset</returns> public static DataSet ExecuteDataset(SqlQuery q, DatabaseProperty dp) { SqlDataAccess da = new SqlDataAccess(dp.ConnectionString); da.Open(); DataSet ds = da.ExecuteDataset(q); da.Close(); return ds; }
public DescriptionColumnBuilder(DatabaseProperty property, Entity entity) { _property = property; _entity = entity; }
public static DataAccess CreateSqlDataAccess(DatabaseProperty dp) { return(new DataAccess(dp.Writer.ConnectionString)); }
public string GetProperty(DatabaseProperty property) { return(_properties[property]); }