Connection string examples

LocalDB adventure

ADO.Net. Connection

ADO.NET. Connection pool

SQLNonQuery Execute

ADO.NET. SqlDataReader

Getting scalar values from DB

Queries with params

Transactions

Stored Procedures

Out params of the stored procedures

SaveInBlob, read from Blob

Transactions

---

SQLAdapter and DataSet

 

SQLAdapter and DataSet theory

Pagination with SQLAdapter

SqlCommandBuilder

Update DB and Dataset manually

All DB Operations example

DataSet и DataTable

Relations beetwen tables in DataSet

LINQ to DataSet

DataSet and XML

---

LINQ TO SQL

 

Linq to SQL Intro

Some operations in LINQ to SQL

Update objects in LINQ to SQL

Insert objects in LINQ to SQL

Delete objects in LINQ to SQL

DataContext. ExecuteCommand и ExecuteQuery