CRUD Operation Related to SQL

Question

Hi to everyone,

 

I New to C# programming,  and finding very difficult to understand connectivity to database and specially CRUD Operation.

 

there are so many SQL components Like

 

SqlCommand

SqlDataAdapter

SqlDataReader

Dataset

DataTable

 

Just to get the Select Statment to work.

 

Does anyone advice me where to use what or where i can learn about this clearly

 

Thanks