linq to db

We have hosted the application linq to db in order to run this application in our online workstations with Wine or directly.

Quick description about linq to db:

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

Programming Language: C#.
Categories: