Roadmap › 1. .NET › Step 13
ADO
ADO.NET — Connected & Disconnected Data Access
Connected vs disconnected architecture, SqlConnection, SqlCommand, DataReader, DataSet/DataAdapter, parameters, stored procedures, transactions, connection pooling, bulk copy, async and Dapper micro-ORM.
Interview priority:★ Must know High priority — asked in almost every interview, learn firstMedium asked regularlyLow good to know
Module 1: Connected Architecture
- 1.Core objects and the connected modelBasic ★ Must know
- 2.ExecuteReader vs ExecuteScalar vs ExecuteNonQueryBasic ★ Must know
- 3.Parameters and SQL injectionBasic ★ Must know
- 4.Stored procedures and output parametersIntermediate ★ Must know
Module 2: Disconnected Architecture
- 5.DataSet, DataTable and DataAdapterIntermediate Medium
Module 3: Transactions, Pooling and Performance
- 6.TransactionsIntermediate ★ Must know
- 7.Connection poolingIntermediate ★ Must know
- 8.Bulk operations and asyncIntermediate Medium
- 9.Dapper micro-ORMIntermediate ★ Must know
Next course in the roadmap: 14. LINQ — Language Integrated Query →