Language Support

  • C#, Visual Basic .NET (VB .NET)

Database Support

  • Microsoft SQL Server, Microsoft Access, MySQL
  • Ability to extend the provider model for any OLEDB or ODBC source

General

  • 100% managed code
  • No special query language to learn
  • No restrictions on names of tables, views, or fields
  • Support for multi-database projects
  • Runs safely under Medium Trust

GUI/Code Generator

  • Customize generated code and runtime behavior of classes.
  • Save/Load configuration files
  • Sync database schema changes at any time, and retain all previous settings

Generated SQL Code

  • Uses parameterized values (protects against SQL injection attacks)
  • Special characters in table/field names automatically escaped
  • Code is dynamically generated for maximum efficiency

Generated Classes

  • Smart class and property naming (automatically makes plural/singular where appropriate)
  • Override members and add custom code
  • Regenerate classes without losing any code you've added
  • Access class meta data at runtime

Tables

  • Support for auto identity columns and composite primary keys

Relationships

  • One to many, Many to one, Many to many, Reflexive (self referencing)

Data Columns

  • Any data type that can be mapped to a .NET system type is supported
  • Support for nullable columns

Data Manipulation

  • INSERT (automatic retrieval of auto-identity value)
  • UPDATE
  • DELETE

Data Retrieval (SELECT)

  • Supports record filtering (WHERE), paging/limiting (LIMIT, TOP), and sorting (ORDER BY)
  • Ability to group (GROUP BY, HAVING) and aggregate records
  • Support for multi-table queries (JOIN)
  • Single value queries and use of database functions (AVG, SUM, etc.)

Concurrency

  • Optimistic, Pessimistic (transactions), Incremental

Data Binding

  • Bindable object list with automatic persistence
  • ObjectDataSource integration for web applications

Performance

  • In-memory data cache
  • Lazy loading
  • Keep-alive connections
  • Smart updates (updates modified fields only)

Auto SQL API

  • Consistent framework for interacting with your database
  • Enhanced services for working with generated data classes
  • Access to ADO .NET objects such as data adapters and readers