. NET Lightweight ORM Framework Dapper Primer Mastery

I. Introduction of the Course

This sharing course contains two sections of the. NET lightweight ORM Framework dapper practicing manual and . NET lightweight ORM Framework Dapper Sunflower Treasure Book, a stupid will lead you to appreciate the lightweight ORM framework dapper charm.

This sharing course is suitable for people:

First, the. NET Lightweight ORM Framework Dapper Training Manual is suitable for people as follows:

1, I am a novice, the main job is for the MS SQL Server database, then choose the Practice manual must be correct.

2, to Dapper never know or understand the incomplete students, want to learn to further enhance the understanding of dapper.

3, the urgent want to improve the next ADO real-combat technology and Transact-SQL writing ability.

Second, the. NET lightweight ORM Framework Dapper Sunflower Treasure Book "Suitable for the crowd as follows:

1, I am a novice, the main job is MySQL database, then choose Sunflower Treasure Book must be right.

2, on the basis of the dapper cultivation manual, a new dapper expansion library Dapper.simplecrud.

3, how to use dapper operation MySQL database and dapper how to support multi-database.

4, the study dapper in the actual project several commonly used development architecture pattern. (Simple three-tier architecture mode, Factory mode, repository architecture mode)

5, this new dapper how to use the transaction in an elegant way. (Highly recommended)

Second, the course knowledge points

2.1, ". NET lightweight ORM Framework Dapper Practice manual covering knowledge points

1. C # LINQ to XML technology.

2. The handbook of Transact-SQL cultivation. such as how to use temporary tables, create user-defined tables (table), XML data fields, Row_number paging functions, stored procedure practice Manuals (Dynamic execution SQL, exception handling mechanism, transaction mechanism), C # How to get the output of the stored procedure, return parameter value.

3, SQL Sever FOR XML technology (XML PATH, XML RAW, XML Auto Simple usage introduction).

4. Transact-SQL keyword OPENXML the XML document in the Operation memory.

5, Faker.net imitate the test data frame application.

6, vs unit Test nuittest use.

7. The application of dapper in asynchronous programming (Asyn Task).

8, the original dapper simple crud (increase and revise) practice manual. (Highly recommended)

9, dapper How to use dynamicparameters dynamic splicing query SQL practice manual. (Highly recommended)

10, dapper Expansion library dapper.sqlbuilder, Uniquenamespace.sqlbuilder practice Manual. (Highly recommended)

11, the native dapper Advanced skill practice manual. (Highly recommended)

12, Dapper Expansion library dapper-extensions practice manual. (Highly recommended)

2.2, ". NET lightweight ORM Framework Dapper Sunflower Treasure Book covering knowledge points

1,. NET Programmer's basic understanding and understanding of MySQL database and its use.

2, how to use. NET lightweight ORM Framework dapper operation MySQL database.

3, faker.net imitate the test data frame application.

4, vs unit Test nuittest use.

5. The application of dapper in asynchronous programming (Asyn Task).

6, the original dapper simple crud (increase the deletion check) Sunflower Treasure Book. (Highly recommended)

7, Dapper Expansion Library Dapper.simplecrud basic use. (Highly recommended)

8, dapper How to dynamicparameters dynamic splicing query SQL Sunflower Treasure Book. (Highly recommended)

9, Dapper Expansion library dapper.sqlbuilder, Uniquenamespace.sqlbuilder Sunflower Treasure Book. (Highly recommended)

10, the original dapper Advanced techniques Sunflower Treasure Book. (Highly recommended)

11, Dapper Expansion library dapper-extensions sunflower treasure. (Highly recommended)

Third, the online source view address

. NET Lightweight ORM Framework Dapper Primer Mastery