Link to home
Start Free TrialLog in
Avatar of deleyd
deleydFlag for United States of America

asked on

C# to SQL

What is the latest & greatest way to access and manipulate data stored in a Microsoft SQL server?

I suspect right now we're doing it in an archaic way.

Dim sqlConnection As New SqlClient.SqlConnection(sqlConnectionString)
Dim sqlCommand As New SqlClient.SqlCommand(sqlStoredProcedure, sqlConnection)
sqlConnection.Open()
sqlCommand.ExecuteNonQuery()
sqlConnection.Close()

Open in new window

(Yes it's VB code)

Is LINQ the way to go nowadays?
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial