using System.Data.SqlClient; using System.Data; // Set up SQL Connection string and command string connString = "Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;"; string queryString = "SELECT * FROM MyTable"; using (SqlConnection connection = new SqlConnection(connString)) { SqlCommand command = new SqlCommand(queryString, connection); connection.Open(); // Create SqlDataReader and iterate over results using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { // Read values from IDataRecord int id = reader.GetInt32(0); string name = reader.GetString(1); DateTime date = reader.GetDateTime(2); decimal price = reader.GetDecimal(3); // Do something with values } } }
using CsvHelper; using CsvHelper.Configuration; using System.IO; // Set up CSV file reader and configuration using (var reader = new StreamReader("path/to/file.csv")) { var csvConfig = new CsvConfiguration(CultureInfo.InvariantCulture); csvConfig.HasHeaderRecord = true; // Create CsvDataReader and iterate over results using (var csvReader = new CsvDataReader(reader, csvConfig)) { while (csvReader.Read()) { // Read values from IDataRecord int id = csvReader.GetInt32(0); string name = csvReader.GetString(1); DateTime date = csvReader.GetDateTime(2); decimal price = csvReader.GetDecimal(3); // Do something with values } } }In the first example, we use SqlDataReader to read records from a SQL Server database. In the second example, we use CsvDataReader from the CsvHelper package to read records from a CSV file. The package used in the second example is CsvHelper, which provides a fast and flexible way to read and write CSV files in C#.