Dapper - Getting Started

Create a migration to add a companies table with columns name, address, city, state, postal code and an identity primary key in the Dapper database, then update the database.

Implement an entity framework repository for companies, define ICompanyRepository with CRUD methods (find, get all, add, update, remove), and a concrete EF repository to execute these operations.

Learn to implement employee create, edit, and delete with dapper, populating a company dropdown via a view bag and repository. Use projections to build select list items for the form.

Implement crud operations for a company using stored procedures via entity framework migrations, including creating, retrieving, updating, and deleting, using migration builder sql and testing in the database.

Apply dynamic parameters with dapper to implement update and remove using stored procedures, including passing the company ID, using a USP_update_company, and db.execute, and validate CRUD operations.

Use Dapper Contrib to get all and get a single company. Resolve table name mismatches by adding a table attribute and using full paths to avoid ambiguity, enabling successful retrieval.

Learn to use dapper contrib for crud: insert returns the new id, update uses the entity pattern, and delete supports single or multiple entities.

Expand Dapper knowledge by implementing a bonus repository with a public interface and an IBonusRepository, wire it in startup with add scoped, and set up for more complex scenarios.

Replace company id with company name by populating company data in the employees index. Discuss the N+1 query problem and explore 1-to-1 mapping in Dapper.

Learn how to implement a one-to-one relation in Dapper by joining employees with their company in a single query, mapping two models into an employee with a company.

Explore implementing a one-to-one relation with parameters by filtering employees by optional company id in SQL, using a conditional where clause and parameter passing.

Learn to add dummy records by creating a company with two employees using a bonus repository method, inserting the company and its employees, then redirecting to the index.

Explore asynchronous programming with Dapper, converting sync methods to async variants like query async and add async, using await and task across the repository and controller.