Telerik, a development company focused on delivering user interface components, has a terrific, free .NET ORM library called OpenAccess. ORM is an acronym for “object relational mapping.” The ORM library takes over the connection strings and queries in an application’s data layer. The main benefit is that you are free write LINQ queries to concrete (POCO) classes, instead of concatenating SQL queries inside of C# code.
I’ve been using the fluent API and I love it. The fluent API lets me map databases to classes using only a few lines of code. All I have to do to instantiate a database context, declare a mapping to the metadata, and then I can query my database using LINQ.
I have to admit that I really enjoy using Telerik’s libraries. I have also developed enterprise websites, reports and portals using their ASP.NET MVC AJAX control library and am impressed with the level of details they put into their components. If you’ve never used a Telerik component before, I highly recommend their free decompiler, JustDecompile.
No need to pay hundreds of dollars for DNN forms and modules when you get enterprise ready controls right out of DotNetNuke (as of v. 6.2.2). Yes, that’s correct, DNN comes with all the Telerik web controls for free!