C# ile Veritabanı İşlemleri: Bağlantı, Sorgu ve Güncelleme

Veritabanına Bağlantı Kurma:

using System;
using System.Data.SqlClient;

class VeritabaniIslemleri
{
static string connectionString = "Data Source=server;Initial Catalog=database;User ID=username;Password=password";

static void Main()
{
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();

// Veritabanı işlemleri yapılacak

connection.Close();
}
}

Veri Sorgulama:

using System;
using System.Data.SqlClient;

class VeritabaniIslemleri
{
static string connectionString = "Data Source=server;Initial Catalog=database;User ID=username;Password=password";

static void Main()
{
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();

string query = "SELECT * FROM Customers";
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader reader = command.ExecuteReader();

while (reader.Read())
{
Console.WriteLine(reader["FirstName"] + " " + reader["LastName"]);
}

reader.Close();
connection.Close();
}
}

Teşekkürler