Database Schema Reader 是一个简单的，跨数据库的数据库元数据读取工具，可以基于 .NET 2.0 DbProviderFactories 读取数据库元数据。
任意的 ADO provider 都可以被读取 (SqlServer, SqlServer CE 4, MySQL, SQLite, System.Data.OracleClient, ODP, Devart, PostgreSql, DB2...) 成单个模块。
简单代码示例
//To use it simply specify the connection string and ADO provider (eg System.Data,SqlClient or System.Data.OracleClient)
const string providername = "System.Data.SqlClient";
const string connectionString = @"Data Source=.\SQLEXPRESS;Integrated Security=true;Initial Catalog=Northwind";
//Create the database reader object.
var dbReader = new DatabaseReader(connectionString, providername);
//For Oracle, you should always specify the Owner (Schema).
//dbReader.Owner = "HR";
//Then load the schema (this will take a little time on moderate to large database structures)
var schema = dbReader.ReadAll();
//There are no datatables, and the structure is identical for all providers.
foreach (var table in schema.Tables)
{
//do something with your model
}
-
下载地址： http://dbschemareader.codeplex.com/releases/view/612307 Contents DatabaseSchemaReader.dll - Class library (.net3.5) DatabaseSchemaViewer.exe - UI to read and view database schemas; options to ge
-
Problem: There are two SQL databases (dev and live) with on Azure which has identical table structures but different table schema name. We need a way to change the schema name at runtime thus we can m
-
本文为您介绍Gbase8a Reader支持的数据类型、字段映射和数据源等参数及配置示例。 背景信息 Gbase8a是一款基于列存储的新型分析型数据库，Gbase8a Reader插件实现了从Gbase8a读取数据的功能。 注意 目前Gbase8a Reader仅支持使用独享数据集成资源组，不支持使用默认资源组和自定义资源组。 Gbase8a Reader通过JDBC连接器连接至远程的Gbase8