using CY.Utility.DBUtility.SqlServerUtility; using System.Data.SqlClient; string connectionString = "Data Source=myServerAddress;Initial Catalog=myDatabase;User ID=myUsername;Password=myPassword;"; string commandText = "SELECT * FROM Customers"; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); using (SqlDataReader reader = SqlServerUtility.ExecuteSqlReader(connection, commandText)) { while (reader.Read()) { // Do something with the data... } } }
using CY.Utility.DBUtility.SqlServerUtility; using System.Data.SqlClient; string connectionString = "Data Source=myServerAddress;Initial Catalog=myDatabase;User ID=myUsername;Password=myPassword;"; string commandText = @"SELECT c.*, o.OrderDate, o.TotalAmount FROM Customers c INNER JOIN Orders o ON c.CustomerID = o.CustomerID"; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); using (SqlDataReader reader = SqlServerUtility.ExecuteSqlReader(connection, commandText)) { while (reader.Read()) { // Do something with the data... } } }In both examples, the SqlServerUtility.ExecuteSqlReader method is used to execute the SQL commands and retrieve the data as a SqlDataReader. The first example retrieves all rows from a single table, while the second example retrieves data from multiple related tables using a JOIN statement.