Core features
Data access layer generation
Core capabilities for generating .NET data access code.
- Rapid Data Access Layer Code Generation for .NET
- Easy to learn and use
- Generates high performance, extensible code for .NET 2.0 and higher
- Generates both C# and VB.NET source code
- Supports multiple database types (e.g. Microsoft SQL Server AND Oracle) from a single codebase
- Infers business entities from existing database metadata
- Supports and generates both dynamic SQL statements and stored procedures
- Detects and integrates schema changes to ease code maintenance
Supported databases
Database compatibility
Database engines supported by SchemaCoder 1.9.
- Microsoft SQL Server 7.0, 2000, 2005, and 2008
- Oracle Database 9i, 10g, and 11g
- Microsoft Access
- MySQL 4.x and 5.x
- Microsoft SQL Server Compact Edition
- SQLite
Advanced features
Extended capabilities
Additional functionality included in the full product.
- Supports long binary (i.e. blob / image) and large text (i.e. text / memo) data types
- Supports streaming of large data types to and from input/output streams
- Supports autonumber (i.e. Identity / Sequence) generated primary keys
- Supports autogenerated Guid primary keys
- Supports insert/update timestamp column types
- Creates Microsoft Visual Studio 2005 project and solution files
- Contains database schema browsing capabilities
- Supports table/schema object conversion between supported databases
- Creates .NET 3.x WCF DataContract and DataMember attributes
- Creates scalar and count(*) methods with aggregate function support