How do I connect to a database using C#

To connect to a database using C#, you typically use ADO.NET, which provides a set of classes for working with data from various sources. The following example demonstrates how to connect to a SQL Server database, execute a simple query, and retrieve data.

using System; using System.Data.SqlClient; class Program { static void Main() { string connectionString = "Server=your_server;Database=your_database;User Id=your_username;Password=your_password;"; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); string sql = "SELECT * FROM your_table"; SqlCommand command = new SqlCommand(sql, connection); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Console.WriteLine(reader["column_name"].ToString()); } } } } }

C# database connection ADO.NET SQL Server SqlConnection SqlCommand SqlDataReader

Related Questions

How do I avoid rehashing overhead with std::set in multithreaded code?

How do I find elements with custom comparators with std::set for embedded targets?

How do I erase elements while iterating with std::set for embedded targets?

How do I provide stable iteration order with std::unordered_map for large datasets?

How do I reserve capacity ahead of time with std::unordered_map for large datasets?

How do I erase elements while iterating with std::unordered_map in multithreaded code?

How do I provide stable iteration order with std::map for embedded targets?

How do I provide stable iteration order with std::map in multithreaded code?

How do I avoid rehashing overhead with std::map in performance-sensitive code?

How do I merge two containers efficiently with std::map for embedded targets?