public bool AddExtendedproperty(string table, string column, string description)
{
var propertysql = services.AddExtendedproperty(FreeSqlFactory.GetDataType);
propertysql = string.Format(propertysql, table, column, description);
return(FreeSqlFactory.GetFreeSql().Ado.ExecuteNonQuery(propertysql) > 0);
}
public bool ModifyTableExtendedproperty(DataBaseConnection baseConnection, string table, string description)
{
var propertysql = services.ModifyTableExtendedproperty(baseConnection.DataBaseType);
propertysql = string.Format(propertysql, table, description);
return(FreeSqlFactory.GetFreeSql(baseConnection.DataBaseType, baseConnection.ConnectinString).Ado.ExecuteNonQuery(propertysql) > 0);
}
public List <Column> GetColumns(DataBaseConnection baseConnection, string tableName)
{
var columnsql = services.GetColumns(baseConnection.DataBaseType);
columnsql = string.Format(columnsql, tableName);
return(FreeSqlFactory.GetFreeSql(baseConnection.DataBaseType, baseConnection.ConnectinString).Ado.ExecuteDataTable(columnsql).ToList <Column>());
}
public List <Column> GetColumns(string tableName)
{
var columnsql = services.GetColumns(FreeSqlFactory.GetDataType);
columnsql = string.Format(columnsql, tableName);
var list = FreeSqlFactory.GetFreeSql().Ado.ExecuteDataTable(columnsql).ToList <Column>();
list.ForEach(x => x.ColumnName = x.ColumnName.ToFirstCharToLower());
return(list);
}
public List <Table> GetTables()
{
var tablesql = services.GetTables(FreeSqlFactory.GetDataType);
return(FreeSqlFactory.GetFreeSql().Ado.ExecuteDataTable(tablesql).ToList <Table>());
}
public List <Table> GetTables(DataBaseConnection baseConnection)
{
var tablesql = services.GetTables(baseConnection.DataBaseType);
return(FreeSqlFactory.GetFreeSql(baseConnection.DataBaseType, baseConnection.ConnectinString).Ado.ExecuteDataTable(tablesql).ToList <Table>());
}