DatabaseSchemaReader是一个简单的,跨数据库的数据库元数据读取工具,可以基于.NET2.0DbProviderFactories读取数据库元数据。
任意的ADOprovider都可以被读取 (SqlServer,SqlServerCE4,MySQL,SQLite,System.Data.OracleCliet,ODP,Devart,PostgreSql,DB2...)成单个模块。
简单代码示例
//To use it simply specify the coectio strig ad ADO provider (eg System.Data,SqlCliet or System.Data.OracleCliet)cost strig providerame = "System.Data.SqlCliet";cost strig coectioStrig = @"Data Source=.\SQLEXPRESS;Itegrated Security=true;Iitial Catalog=Northwid";//Create the database reader object.var dbReader = ew DatabaseReader(coectioStrig, providerame);//For Oracle, you should always specify the Ower (Schema).//dbReader.Ower = "HR";//The load the schema (this will take a little time o moderate to large database structures)var schema = dbReader.ReadAll();//There are o datatables, ad the structure is idetical for all providers.foreach (var table i schema.Tables){ //do somethig with your model}
评论