.NET equivalent of VFP SQL Pass-Through (i.e. without using EF or LINQ)

Hi all

In VFP we can do this

lnConnection = SQLSTRINGCONNECT(cConnectString) SQLEXEC(lnConnection,"Select * From cname") && puts results into SQLRESULT

I am wondering what is the nearest equivalent in .NET This is what I have come up with, but is there a better way?

SqlConnection sqlConnection1 = new SqlConnection(cConnectString); SqlCommand cmd = new SqlCommand(); SqlDataReader reader; cmd.CommandText = "SELECT * FROM cname"; cmd.CommandType = CommandType.Text; cmd.Connection = sqlConnection1; sqlConnection1.Open(); reader = cmd.ExecuteReader();

Also how would I approach UPDATE and DELETE etc?

Many thanks

Paul Newton