SQL
using Microsoft.Data.SqlClient;
using System.Data.SqlTypes;
using System.Drawing;
internal class Program
{
private static void Main(string[] args)
{
Console.WriteLine("Hello, World!");
SqlConnection? conn = null;
SqlDataReader? reader = null;
try
{
string connectionString = "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=FlowerShop;Integrated Security=True;Connect Timeout=30;Encrypt=False;Trust Server Certificate=False;Application Intent=ReadWrite;Multi Subnet Failover=False";
conn = new SqlConnection(connectionString);
conn.Open();
Console.WriteLine(
conn.State == System.Data.ConnectionState.Open ?
"Соединение установлено" : "Ошибка подключения"
);
//string sqlString = @"insert into Flowers
//(Title,Price,Color) values
//('Sunflower',1000,'Yellow')";
//SqlCommand cmd = new SqlCommand( sqlString, conn );
//cmd.ExecuteNonQuery();
string sqlString = @"select * from Flowers";
SqlCommand cmd = new SqlCommand(sqlString, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.WriteLine($"{reader["Color"]} {reader[1]} - {reader[2]}");
}
}
finally
{
if(reader != null)
reader.Close();
if (conn != null)
{
conn.Close();
}
}
}
}