Features related to Linq to SQL

To use Linq to Sql, you have all the designer features at your disposal. Choosing Linq to Sql as target framework allows you to generate code from the entity model in your project. The following list gives an overview of the various aspects of that generated code, what options are available to you and which functionality is available to you to configure the generated code and control what the generated code looks like.

The Databases which are supported for Linq to Sql
- SQL Server 2000 or higher
- CE Desktop 3.5 or higher
Configure the generated code using a wide range of settings.
The designer offers specific settings for Linq to Sql. For more details see Linq to Sql settings
Support for Xml and attribute based mappings
Through a setting you can choose whether you want the mappings to be embedded into the classes as attributes or be generated as an external XML file. More information...
Designer constructs and their effect on the generated code
- Entities can be mapped onto a table, view or resultset of a table valued function and are available as normal classes.
- Fields mapped onto a related field are available at the entity class level.
- Typed Lists are generated as linq queries. This allows you to design projections over model elements in the LLBLGen Pro designer and use them using linq in your code. More information...
- Action stored procedure calls are generated as methods on the generated datacontext class and use the Linq to Sql built-in way to call the stored procedure. More information...
- Retrieval stored procedure calls are also generated as methods on the generated datacontext and return un-typed data in datatables/sets, if no TypedView is mapped onto the resultset(s) More information...
- Typed Views mapped onto a stored procedure resultset are resulting in a method onto the generated datacontext to call the stored procedure and obtain a typed resultset. Multiple resultset returning stored procedures are supported. More information...
- Typed Views mapped onto a table or view are usable as entities and retrievable as entities.
  More information...
Generated code is compatible with Microsoft's own generated code.
If you are used to the generated code generated with Microsoft's own Linq to Sql designer, using the generated code produced by LLBLGen Pro is very easy as the features found in Microsoft's own generated code are also found in LLBLGen Pro's generated code.
Generated code is source-control friendly and well documented.
The generated code is designed to be generated in the same form every time so elements appear at the same position and are named the same. Every element is documented with XML document elements to make it easy to produce XML Doc reference manuals.