Powerful Data Access Layer Code Generation For .NET
There are few areas of software development more tedious and error prone than writing data access layer code. There are also few areas of software development that lend themselves so well to computer assistance. Numerous tools and techniques have been devised to assist with this effort. Microsoft Visual Studio itself has a number of tools built in.
Most of the tools on the market suffer from one of several maladies. Many tools are written to the lowest common denominators of functionality of the data sources they support and either fail to take advantage of some of the advanced features of the database or fail to support some of the less common data types. Other tools are written to be the swiss army knife of code generation and are consequently overly complex to learn and use for the developer that wants to hit the ground running and get the job done in a simple, direct fashion.
Schematrix SchemaCoder has been created to help alleviate many of the issues found with other tools and to help the developer get the job done faster and more reliably than if it were done "the old-fashioned way". Code generation is all the rage these days for many good reasons. With Schematrix SchemaCoder, you will experience all the following:
- Huge Time Savings – Manually creating data access code takes time and a lot of it. Schematrix SchemaCoder creates both the necessary SQL code (Dynamic or Stored Procedures) and the .NET code (C# or VB.Net) for calling it. The cost of a Schematrix SchemaCoder license is generally less than a single day’s salary for a developer and can easily pay for itself within the first week of use.
- Higher Code Quality – Writing data access code is tedious and error prone. Remembering and manually typing column names is pure drudgery. Many errors cannot be detected by compilers and will go unnoticed until runtime. Automating as much of this type of code as possible greatly lessens these types of errors.
- Faster Time-To-Market – By automating the data access layer code, developers have much more time to concentrate on the other areas of the application (e.g. user interface and business logic) and can develop better products faster.
- Consistency – Without extremely rigid and difficult to enforce development standards, data access code written by different developers will vary in structure and quality, making it difficult to transfer ownership of code from one developer to another. Using Schematrix SchemaCoder will add a high degree of consistency to the data access code and more easily enable code reuse between developers and projects.
Core Features
- 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
- 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
- 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
Main User Interface
Project Options
Database Browser
Schema Converter
Code Viewer
下载地址：http://www.fosoyo.com/article.asp?id=149
