public void CreateTable(RelationModel relation) { var a = SQL.CreateTable.CreateTb(relation.TbName); foreach (var c in relation.Columns) { a.AddColumn(c.ColumnName, c.TypeName, c.Size, c.ConstraintsStr); } SqlScript sql = a.ToSql(); DbServerProvider.ExcuteNonQuery(CommandType.Text, sql.ToString()); }
/// <summary> /// 处理数据库异常 /// </summary> /// <param name="ex"></param> /// <returns>处理成功返回true,否则返回false</returns> private bool ProcessSqlException(Exception ex) { SqlException sqlEx = DbServerProvider.ConvertToSqlException(ex); switch (sqlEx.Number) { case 4060: CreateDb(DbServerProvider.DataBase); return(true); default: return(false); } }
public bool IsTableExist(string tableName) { string sql = string.Format("select count(1) from sys.objects where name = '{0}'", tableName); int res = (int)DbServerProvider.ExcuteScalar(CommandType.Text, sql); if (res == 1) { return(true); } else { return(false); } }
/// <summary> /// 获取数据集 /// </summary> /// <param name="sql"></param> /// <returns></returns> public DataSet GetDataSet(SqlScript sql) { var res = DbServerProvider.ExcuteDataSet(CommandType.Text, sql.ToString()); return(res); }
public void CreateDb(string dataBaseName) { DbServerProvider.ExcuteNonQuery(CommandType.Text, CreateDB.CreateDb(dataBaseName).ToSql().ToString()); }