. NET lightweight ORM components dapper Sunflower Treasure Book

I. Summary

Why the name "Sunflower Treasure"?

From the world perspective of walking, you can be understood as a "martial arts cheats", standing in our IT programming world perspective should be called "Development treasure."

If you're working on a MySQL database, you want to learn and learn. NET lightweight ORM Framework Dapper, then please follow the study of this sharing lesson. NET lightweight ORM Framework Dapper Sunflower Treasure Book. Let's Go,do It, Dapper for mysql!

Needless to say, directly on dry goods, we do not produce dry goods, we are just dry goods porter.

Second, the course is suitable for the crowd

Q: How do I choose the Dapper Practice Handbook and the dapper Sunflower treasure Book?

A: The combination of their own needs, the choice of the right.

2.1. 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.

4, detailed about the dapper practice manual can go to before a stupid public class to see the course description.

2.2, ". 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 handle transactions and elegant way to use the transaction. (highly recommended)

Iii. Environmental Preparedness

3.1. mysql for Windows Database installation.

3.2. Introduction and use of MySQL graphical management tools.

3.3, MySQL monitoring tool installation and basic use.

3.4. SQL Server test database is converted to MySQL database.

1), use the Mss2sql tool to convert SQL Server to MySQL.

2), Navicat for MySQL Data Import Wizard feature. (Highly recommended)

Note: After the data import is complete, you must remember to reset the data type of the build from Growth column, indexed field, and set field.

3.5, T4 template engine basic introduction and simple use.

Iv. knowledge points relating to coverage

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 use dynamicparameters dynamic splicing query SQL practice manual. (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)

4.1, native dapper simple crud (increase and deletion of check)

Insert, Insert_batch (BULK insert data).

Update, Delete, Exist.

GetById, GetList, getbyids (in clause use).

Getlistreturndynamic (returns dynamic).

Getlistbymultiquery (returns a multi-result set tuple).

Executewithdbtransaction (local dbtransaction transaction operation).

Executewithtransactionscope (distributed TransactionScope Transaction Operations).

4.2, the basic use of Dapper expansion library Dapper.simplecrud

Insert, Delete, Exist, Insert_batch

GetById, GetList

Getlistpaged (Gets the paging data, obtains the total record number and the paging data respectively through the Dapper.simplecrud RecordCount, the getlistpaged function. ）

4.3, dapper How to use dynamicparameters dynamic splicing query SQL practice Manual

Insert, Getlistbygenreidandname appreciate the dynamicparameters style.

Searchordersbypagedynamicparameterssqlbuild: Get Paging data (by dynamicparameters dynamic stitching Query SQL method stitching + row_number () over clause paging).

4.4. Dapper Expansion Library Dapper.sqlbuilder training manual

Constructs a crud statement template through Sqlbuilder.

Constructs a Select (query), page (pagination) statement template by Sqlbuilder the built-in template.

Searchordersbypagedappersqlbuilder: Gets paging data (paged by Dapper.sqlbuilder + limit clause).

Searchordersbydapperdappersqlbuildersqlpagingtemplates gets paging data (paginated by Dapper.sqlbuilder the built-in paging template).

4.5, the native Dapper Advanced Skill Practice Handbook

Createorder: Create order (with SQL stitching +for loop).

Getorderonetomanybysqlbuilder: Get Orders (one-to-many) through the master-slave table SQL statement mode.

Getorderonetomanybydapperquery: Get Orders (one-to-many) through native dapper Query+spliton keywords.

Searchordersbypagesqlbuild: Gets paging data (paged by SQL statement concatenation + limit clause).

4.6. Dapper Expansion Library Dapper-extensions training manual

1, insert, Insert_batch (BULK insert data).

2, Update, Delete, Exist.

3, GetList: Contains the following knowledge points:

* Query based on criteria (with filters and sort fields).

* Queries based on multi-combination criteria (Predicates.group () of ipredicate generates filter conditions + sort fields).

* Queries based on multiple combinations of criteria (Ipredicate.add () to generate filter conditions + sort fields).

* Queries based on multiple combinations of criteria (predicate multiple conditional compound predicate combinations to generate filter conditions + Sort fields, sample SQL statements: Select * from Table Where ([email protected] and [ Email protected]) OR ([email protected] and [email protected]).

* Subquery query based on single criteria (via Ipredicate.exists () subquery filter condition statement + sort field, sample statement: Select * form Table Where       EXISTS ( Select 1 from Table Where [email protected]).

* Subquery query based on multi-combination criteria (via ipredicate.exists () subquery filter condition statement + sort field, sample statement: SELECT * from Table Where EXISTS (select Count (1) from Table Where ([email protected] and [email protected]) OR ([email protected] and [email protected]) )）。

*searchordersbypagedapperextensions: Gets the paging data (the built-in count, page function is ipredicate+ by the provided extended dapperextensions multi-conditional composite predicate).

Vi. Summary

1, in the World of ADO "Handbook" and "Treasure" in hand, unimpeded, rampant world.

2, hope to learn this sunflower treasure Book, you will be drawn to a full of dry goods, so you have more confidence! So stupid will also feel a hint of comfort.

3, the last of a stupid vision: strive to pass this two times about Dapper sharing class, to do the present. NET aspect about Dapper's most comprehensive tutorial. Be a little humble to the rise of. NET!

4, Q: How to effectively study "Dapper Cultivation Handbook" and "Dapper Sunflower Treasure book"?

A: Stupid gives the suggestion is that you download the source code after each test case for debugging and learning, so that you can understand and skilled use of dapper.

. NET lightweight ORM components dapper Sunflower Treasure Book