Home

Any ADO provider can be read (SqlServer, SqlServer CE 4, MySQL, SQLite, System.Data.OracleClient, ODP, Devart, PostgreSql, DB2, Intersystems Cache, Ingres...) into a single standard model.

There are utilities and two simple UI projects demonstrating how to use the model:

• View all data from any provider
• Generate POCO classes for tables, and NHibernate mapping files
• Generate simple ADO classes to use stored procedures
• Generate table DDL (and translate to another SQL syntax, eg SqlServer to Oracle or SQLite)
• Generate CRUD stored procedures (for SqlServer, Oracle, MySQL, DB2)
• Copy a database schema and data from any provider (SqlServer, Oracle etc) to a new SQLite database (and, with limitations, to SqlServer CE 4)
• Compare two schemas to generate a migration script

This is intended to be a tool for developers who use simple persistence databases on different platforms. It does not know advanced and provider-specific data types and concepts (geometry, tablespaces, enums). For database specific support, use your database admin UI, schema comparison or conversion tools.

• Overview

API

• Schema Reading - reading the schema from the database
• More Schema Reading - advanced techniques
• Limitations - what this schema reader can and cannot do
• SQL AutoNumbers - dealing with identity and sequences for autonumbering
• SQL Generation - generating SQL from a schema
• SQL Conversion - converting SQL DDL from one database to another
• Code Generation - generating C# classes and projects from a schema
• EF Code First - reverse engineering C# EF Code First projects from a schema
• Database Comparisons - comparing two schemas and making a migration script
• Database Migrations - generating scripts to migrate database schemas
• Writing Data - creating a script of SQL "INSERT"s
• Procedure ResultSets - reading the output of stored procedures
• Data Reading - reading data
• netcore - using with .net Core/Net 6+
• UDTs - user defined types/tables

UI

UI Documentation

Old documentation is available on Codeplex: https://dbschemareader.codeplex.com/documentation