自动获取表结构及Relation

最新推荐文章于 2023-12-31 19:03:51 发布

du9232

最新推荐文章于 2023-12-31 19:03:51 发布

阅读量846

点赞数

分类专栏： .net技术文章文章标签： string table dataset null security sql

本文链接：https://blog.csdn.net/du9232/article/details/398333

版权

.net技术文章专栏收录该内容

16 篇文章 0 订阅

订阅专栏

string myConnString = "Provider=SQLOLEDB;Data Source=server;Initial Catalog=Duwamish7;Integrated Security=SSPI;Connect Timeout=30";

OleDbConnectionconn = new OleDbConnection(myConnString);
DataSetds = new DataSet();
using (conn)
{
    conn.Open();
    //取表
    DataTable dataTalbeschema = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,
new Object[]{ null, null, null,"TABLE" } );
    //取表结构
    foreach (DataRow tableRow in dataTalbeschema.Rows)
    {
String tableName = tableRow["Table_Name"].ToString();
string sql = "select * from " + tableName ;
OleDbDataAdapter oda= new OleDbDataAdapter(sql,conn);
oda.MissingSchemaAction = MissingSchemaAction.AddWithKey;
oda.FillSchema(ds,SchemaType.Mapped,tableName);
    }
    //添加Relation
    DataTable dtfk = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Foreign_Keys,null );
    foreach (DataRow fkRow in dtfk.Rows)
    {
String fkName = fkRow["Fk_Name"].ToString();
DataColumn parentColumn = ds.Tables[fkRow["Pk_Table_Name"].ToString()].Columns[fkRow["Pk_Column_Name"].ToString()];
DataColumn childColumn = ds.Tables[fkRow["Fk_Table_Name"].ToString()].Columns[fkRow["Fk_Column_Name"].ToString()];
ds.Relations.Add(fkName,parentColumn,childColumn);
   }
   conn.Close();
}