MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

.NET Micro ORMs

Course Summary

Do you want a data ORM that is simple and lightweight but also is powerful and provides incredible performance? If so, a Micro ORM is for you! This course will provide background for what a Micro ORM is and why you might want to use one. It will then dive


  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
        ◦ What is A Micro ORM?
        ◦ Counter Arguments
        ◦ Your First Dapper Query
        ◦ Your First OrmLite Query
        ◦ Your First PetaPoco Query
        ◦ Your First Massive Query
        ◦ Your First Simple.Data Query
        ◦ Summary
    ● Dapper
        ◦ Introduction
        ◦ Key Features
        ◦ Database Setup
        ◦ Installing Dapper
        ◦ First Repository and Test
        ◦ Basic List Query
        ◦ Inserting Data
        ◦ Retrieving a Single Item
        ◦ Updating Data
        ◦ Deleting Data
        ◦ CRUD with Complex Objects
        ◦ Stored Procedures
        ◦ Dynamic Parameters
        ◦ Putting a UI on Top
        ◦ Bulk Insert
        ◦ List Support
        ◦ Dynamic Capabilities
        ◦ Summary
    ● OrmLite
        ◦ Introduction
        ◦ Key Features
        ◦ Installing OrmLite
        ◦ Basic List Query
        ◦ Inserting Data
        ◦ Retrieving A Single Item
        ◦ Updating Data
        ◦ Deleting Data
        ◦ CRUD with Complex Objects with Explicit Children
        ◦ Creating and Dropping Tables
        ◦ CRUD with Complex Objects with Blobbed Children
        ◦ Stored Procedures
        ◦ SELECT Expression Support
        ◦ Summary
    ● Massive
        ◦ Introduction
        ◦ Key Features
        ◦ Installing Massive
        ◦ Basic List Query with DynamicModel
        ◦ Inserting Data
        ◦ Retrieving A Single Item
        ◦ Updating Data
        ◦ Deleting Data
        ◦ Paging
        ◦ Named Arguments
        ◦ Aggregates with Named Arguments
        ◦ Metadata
        ◦ Validations
        ◦ Callbacks
        ◦ Summary
    ● PetaPoco
        ◦ Introduction
        ◦ Key Features
        ◦ Installing PetaPoco
        ◦ Basic List Query
        ◦ Inserting Data
        ◦ Retrieving A Single Item
        ◦ Updating Data
        ◦ Deleting Data
        ◦ Using T4 Templates
        ◦ CRUD with Complex Objects
        ◦ Paging
        ◦ SQLBuilder
        ◦ SQL Command Tracking
        ◦ Summary
    ● Simple.Data
        ◦ Introduction
        ◦ Key Features
        ◦ Be Blown Away By Simple.Data.Pad
        ◦ Installing Simple.Data
        ◦ Basic List Query
        ◦ Inserting Data
        ◦ Retrieving A Single Item
        ◦ Updating Data
        ◦ Deleting Data
        ◦ Moving From Dynamic to Static
        ◦ Column Selection
        ◦ Getting Distinct Data
        ◦ Joins
        ◦ Summary
     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top