protected override Key CreateKey(DataRow row)
{
Key key = new Key();
key.Name = row["relname"].ToString();
key.ColumnName = row["relname"].ToString();
key.IsPrimary = Convert.ToBoolean(row["indisprimary"]);
return key;
}
protected override Key CreateKey(DataRow row)
{
Key key = new Key();
key.Name = row["PK_NAME"].ToString();
key.ColumnName = row["FKCOLUMN_NAME"].ToString();
key.IsPrimary = false;
return key;
}
protected override Key CreateKey(DataRow row)
{
Key key = new Key();
key.Name = row["Key_name"].ToString();
key.ColumnName = row["Column_name"].ToString();
key.IsPrimary = row["Key_name"].ToString() == "PRIMARY"?true:false;
return key;
}
protected override Key CreateKey(DataRow row)
{
Key key = new Key();
key.Name = row["CONSTRAINT_NAME"].ToString();
key.ColumnName = row["COLUMN_NAME"].ToString();
if (row["CONSTRAINT_TYPE"].ToString() == "P")
{
key.IsPrimary = true;
}
else
{
key.IsPrimary = false;
}
return key;
}
protected override DataSet KeySchema(Table table, DataAccessProviderFactory dataAccessProvider, IDbConnection connection)
{
DataSet dsPkeys = new DataSet();
IDbCommand sqlSp = dataAccessProvider.CreateCommand("sp_pkeys",connection);
sqlSp.CommandType = CommandType.StoredProcedure;
IDbDataParameter param = dataAccessProvider.CreateParameter();
param.Direction = ParameterDirection.Input;
param.DbType = DbType.String;
param.ParameterName = "@table_name";
param.Value = table.Name;
sqlSp.Parameters.Add(param);
IDbDataParameter schemaParameter = dataAccessProvider.CreateParameter();
schemaParameter.Direction = ParameterDirection.Input;
schemaParameter.DbType = DbType.String;
schemaParameter.ParameterName = "@table_owner";
schemaParameter.Value = table.Schema;
sqlSp.Parameters.Add(schemaParameter);
IDbDataAdapter da = dataAccessProvider.CreateDataAdapter();
da.SelectCommand = sqlSp;
da.Fill(dsPkeys);
foreach(DataRow row in dsPkeys.Tables[0].Rows)
{
Key key = new Key();
key.Name = row["PK_NAME"].ToString();
key.ColumnName = row["COLUMN_NAME"].ToString();
key.IsPrimary = true;
_Keys.Add(key);
}
DataSet ds = new DataSet();
sqlSp = dataAccessProvider.CreateCommand("sp_fkeys",connection);
sqlSp.CommandType = CommandType.StoredProcedure;
param = dataAccessProvider.CreateParameter();
param.Direction = ParameterDirection.Input;
param.DbType = DbType.String;
param.ParameterName = "@pktable_name";
param.Value = table.Name;
sqlSp.Parameters.Add(param);
da = dataAccessProvider.CreateDataAdapter();
da.SelectCommand = sqlSp;
da.Fill(ds);
ds.Merge(dsPkeys);
return ds;
}
public void Remove(Key key)
{
List.Remove(key);
}
public int IndexOf(Key key)
{
return List.IndexOf(key);
}
public bool Contains(Key key)
{
return List.Contains(key);
}
public void Add(Key key)
{
List.Add(key);
}
