Introduction to the Lightweight. Net ORM Framework

<span id="Label3"></p>Light weight ORM Components<span><span>Fluentdata</span></span><p><p><span>Official website https://fluentdata.codeplex.com/</span></p></p><p><p></p></p><p><p><span style="font-size: 18pt;"><strong>Sample Data</strong></span></p></p><p><p></p></p><p><p><span style="font-size: 18pt;"><strong>Dos.orm</strong></span></p></p><p><p></p></p><p><p></p></p><p class="name"><p class="name"><span style="font-size: 18pt;">ORM Framework <span style="text-decoration: underline;">Dapper. NET</span></span></p></p><p class="name"><p class="name"><span style="text-decoration: underline;">Official website Https://github.com/StackExchange/dapper-dot-net</span></p></p><p class="name"><p class="name"></p></p><p class="name"><p class="name"></p></p><p class="name"><p class="name"><span style="font-size: 18pt;">. NET object-relational mapper <span style="text-decoration: underline;">Petapoco</span></span></p></p><p class="name"><p class="name"></p></p><p><p></p></p><p><p></p></p><p><p>Petapoco is a lightweight object-relational mapper (ORM, Object Relational Mapper) for. net Applications. Unlike those full-featured Orm (such as the NHibernate or entity Framework), Petapoco is more focused on ease of use and performance than on rich Functionality. Using petapoco, you only need to introduce a C # file, you can use a strongly typed POCO (Plain old CLR Object), and support classes generated using the T4 template, and so On.</p></p><p><p></p></p><p><p>The most interesting features of Petapoco Include:</p></p><p><p></p></p> <ul> <ul> <li>Works with SQL server, SQL Server CE, MySQL, postgresql, and Oracle Databases.</li> <li>Contains multiple helper methods for Insert/delete/update/save and ISNEW.</li> <li>Supports simple transactions</li> <li>For page flipping requests, the total number of records is automatically calculated and a specific paging is Obtained.</li> <li>Support for parameter substitution, ability to fetch named parameters from object Properties (named Parameters)</li> <li>Includes a SQL builder class that consumes little resources</li> <li>Partial record update</li> <li>Includes T4 Templates, which can be used to generate Poco classes based on the database Structure.</li> </ul> </ul><p><p></p></p><p><p>Detailed instructions and examples for all of these features are available on the Petapoco Website.</p></p><p><p></p></p><p><p>In terms of performance, Petapoco is second only to dapper, at a slower pace than the manually coded data access Layer (DAL, data access layers).</p></p><p><p></p></p><p><p>There are also tutorials that will help beginners, and they are a series of blog posts on the official website as well as some independent post Tutorials. In addition, because Petapoco is an open source project, it is easy to add conditions to handle specific situations such as spatial Data.</p></p><p><p></p></p><p><p>recently, with the release of many open source projects, Mini-orm has begun to become a popular trend. Some other well-known applies To. NET projects are dapper and Massive. Those mini-orm are simpler and more efficient than full-fledged orm, and micro-orm often requires developers to write SQL statements manually rather than fully dynamically. They also do not require lengthy mapping files, because those mapping files can only make the process tedious for maintenance and debugging Purposes.</p></p><p><p></p></p><p><p>Introduction to the Lightweight. Net ORM Framework</p></p></span>