public List <ConstraintInfo> GetPrimaryKeyOnTable(string connectionString, string tableName)
{
List <ConstraintInfo> list = new List <ConstraintInfo>();
SqlConnection conn;
using (IDataReader reader = SqlCommandX.Instance.GetReader(
connectionString, query_pk_on_table(table_name), CommandType.Text,
out conn))
{
while (reader.Read())
{
ConstraintInfo cs = new ConstraintInfo();
if (DBNull.Value != reader["table_name"])
{
cs.table_name = reader["table_name"].ToString();
}
if (DBNull.Value != reader["field_name"])
{
cs.field_name = reader["field_name"].ToString();
}
if (DBNull.Value != reader["constraint_type"])
{
cs.constraint_type = reader["constraint_type"].ToString();
}
if (DBNull.Value != reader["constraint_name"])
{
cs.constraint_name = reader["constraint_name"].ToString();
}
if (DBNull.Value != reader["match_type"])
{
cs.match_type = reader["match_type"].ToString();
}
if (DBNull.Value != reader["on_update"])
{
cs.on_update = reader["on_update"].ToString();
}
if (DBNull.Value != reader["on_delete"])
{
cs.on_delete = reader["on_delete"].ToString();
}
if (DBNull.Value != reader["references_table"])
{
cs.references_table = reader["references_table"].ToString();
}
if (DBNull.Value != reader["references_field"])
{
cs.references_field = reader["references_field"].ToString();
}
if (DBNull.Value != reader["field_position"])
{
cs.field_position = int.Parse(reader["field_position"].ToString());
}
list.Add(cs);
}
}
return(list);
}
/// <summary>
/// Get list of all constraints, you can apply table filter
/// </summary>
public static List<ConstraintInfo> GetConstraints(string connectionString, params string[] filterTables)
{
List<ConstraintInfo> list = new List<ConstraintInfo>();
SqlConnection conn;
string query = filterTables.Length > 0 ? ConstraintInfo.queryWithFilter(filterTables) : ConstraintInfo.query;
using (IDataReader reader = SqlCommandX.Instance.GetReader(
connectionString, query, CommandType.Text, out conn))
{
while (reader.Read())
{
ConstraintInfo cs = new ConstraintInfo();
if (DBNull.Value != reader["table_name"])
{
cs.table_name = reader["table_name"].ToString();
}
if (DBNull.Value != reader["field_name"])
{
cs.field_name = reader["field_name"].ToString();
}
if (DBNull.Value != reader["constraint_type"])
{
cs.constraint_type = reader["constraint_type"].ToString();
}
if (DBNull.Value != reader["constraint_name"])
{
cs.constraint_name = reader["constraint_name"].ToString();
}
if (DBNull.Value != reader["match_type"])
{
cs.match_type = reader["match_type"].ToString();
}
if (DBNull.Value != reader["on_update"])
{
cs.on_update = reader["on_update"].ToString();
}
if (DBNull.Value != reader["on_delete"])
{
cs.on_delete = reader["on_delete"].ToString();
}
if (DBNull.Value != reader["references_table"])
{
cs.references_table = reader["references_table"].ToString();
}
if (DBNull.Value != reader["references_field"])
{
cs.references_field = reader["references_field"].ToString();
}
if (DBNull.Value != reader["field_position"])
{
cs.field_position = int.Parse(reader["field_position"].ToString());
}
list.Add(cs);
}
}
conn.Destroy();
return list;
}
/// <summary>
/// Get list of all constraints, you can apply table filter
/// </summary>
public static List <ConstraintInfo> GetConstraints(string connectionString, params string[] filterTables)
{
List <ConstraintInfo> list = new List <ConstraintInfo>();
SqlConnection conn;
string query = filterTables.Length > 0 ? ConstraintInfo.queryWithFilter(filterTables) : ConstraintInfo.query;
using (IDataReader reader = SqlCommandX.Instance.GetReader(
connectionString, query, CommandType.Text, out conn))
{
while (reader.Read())
{
ConstraintInfo cs = new ConstraintInfo();
if (DBNull.Value != reader["table_name"])
{
cs.table_name = reader["table_name"].ToString();
}
if (DBNull.Value != reader["field_name"])
{
cs.field_name = reader["field_name"].ToString();
}
if (DBNull.Value != reader["constraint_type"])
{
cs.constraint_type = reader["constraint_type"].ToString();
}
if (DBNull.Value != reader["constraint_name"])
{
cs.constraint_name = reader["constraint_name"].ToString();
}
if (DBNull.Value != reader["match_type"])
{
cs.match_type = reader["match_type"].ToString();
}
if (DBNull.Value != reader["on_update"])
{
cs.on_update = reader["on_update"].ToString();
}
if (DBNull.Value != reader["on_delete"])
{
cs.on_delete = reader["on_delete"].ToString();
}
if (DBNull.Value != reader["references_table"])
{
cs.references_table = reader["references_table"].ToString();
}
if (DBNull.Value != reader["references_field"])
{
cs.references_field = reader["references_field"].ToString();
}
if (DBNull.Value != reader["field_position"])
{
cs.field_position = int.Parse(reader["field_position"].ToString());
}
list.Add(cs);
}
}
conn.Destroy();
return(list);
}
public List<ConstraintInfo> GetPrimaryKeyOnTable(string connectionString, string tableName)
{
List<ConstraintInfo> list = new List<ConstraintInfo>();
SqlConnection conn;
using (IDataReader reader = SqlCommandX.Instance.GetReader(
connectionString, query_pk_on_table(table_name), CommandType.Text,
out conn))
{
while (reader.Read())
{
ConstraintInfo cs = new ConstraintInfo();
if (DBNull.Value != reader["table_name"])
{
cs.table_name = reader["table_name"].ToString();
}
if (DBNull.Value != reader["field_name"])
{
cs.field_name = reader["field_name"].ToString();
}
if (DBNull.Value != reader["constraint_type"])
{
cs.constraint_type = reader["constraint_type"].ToString();
}
if (DBNull.Value != reader["constraint_name"])
{
cs.constraint_name = reader["constraint_name"].ToString();
}
if (DBNull.Value != reader["match_type"])
{
cs.match_type = reader["match_type"].ToString();
}
if (DBNull.Value != reader["on_update"])
{
cs.on_update = reader["on_update"].ToString();
}
if (DBNull.Value != reader["on_delete"])
{
cs.on_delete = reader["on_delete"].ToString();
}
if (DBNull.Value != reader["references_table"])
{
cs.references_table = reader["references_table"].ToString();
}
if (DBNull.Value != reader["references_field"])
{
cs.references_field = reader["references_field"].ToString();
}
if (DBNull.Value != reader["field_position"])
{
cs.field_position = int.Parse(reader["field_position"].ToString());
}
list.Add(cs);
}
}
return list;
}