Download
LINQ to DB is the fastest LINQ database access library offering a simple, light, fast, and type-safe layer between your POCO objects and your database. Architecturally it is one step above micro-ORMs like Dapper, Massive, or PetaPoco, in that you work with LINQ expressions, not with magic strings, while maintaining a thin abstraction layer between your code and the database. Your queries are checked by the C# compiler and allow for easy refactoring. However, it's not as heavy as LINQ to SQL or Entity Framework. There is no change-tracking, so you have to manage that yourself, but on the positive side you get more control and faster access to your data. In other words LINQ to DB is type-safe SQL. Alternatively, you can implement custom settings provider with ILinqToDBSettings interface. You can generate POCO classes from your database using T4 templates.
Features
- You can generate POCO classes from your database using T4 templates
- With Fluent approach you can configure only things that require it explicitly
- Rather than concatenating strings we can 'compose' LINQ expressions
- Updating records follows similar pattern to Insert
- Similar to how you update records, you can also delete records
- Bulk copy feature supports the transfer of large amounts of data into a table from another data source
Project Samples
