Program.cs - master - weeny/database

Program.cs
93 строки3 KB
weeny
create: build.bat, DatabaseProject.csproj, DatabaseService.cs, Program.cs, ProgramExamples.cs, README.md, UserRepository.cs
01 июн 2026, 20:14
Верифицирован
01 июн 2026, 20:147de0d86
using Microsoft.Data.Sqlite;
using Dapper;
using System.Data;

class Program
{
    static string connectionString = "Data Source=database.db";

    static void Main(string[] args)
    {
        CreateDatabase();
        CreateTable();
        InsertSampleData();
        QueryData();
    }

    static void CreateDatabase()
    {
        using (var connection = new SqliteConnection(connectionString))
        {
            connection.Open();
            Console.WriteLine("База данных создана успешно!");
        }
    }

    static void CreateTable()
    {
        using (var connection = new SqliteConnection(connectionString))
        {
            connection.Open();
            
            var sql = @"
                CREATE TABLE IF NOT EXISTS Users (
                    Id INTEGER PRIMARY KEY AUTOINCREMENT,
                    Name TEXT NOT NULL,
                    Email TEXT NOT NULL UNIQUE,
                    Age INTEGER,
                    CreatedAt DATETIME DEFAULT CURRENT_TIMESTAMP
                )";

            connection.Execute(sql);
            Console.WriteLine("Таблица Users создана успешно!");
        }
    }

    static void InsertSampleData()
    {
        using (var connection = new SqliteConnection(connectionString))
        {
            connection.Open();
            
            var sql = @"
                INSERT INTO Users (Name, Email, Age) 
                VALUES (@Name, @Email, @Age)";

            var users = new[]
            {
                new { Name = "Иван Иванов", Email = "ivan@example.com", Age = 25 },
                new { Name = "Мария Петрова", Email = "maria@example.com", Age = 30 },
                new { Name = "Алексей Сидоров", Email = "alex@example.com", Age = 28 }
            };

            connection.Execute(sql, users);
            Console.WriteLine("Примеры данных добавлены успешно!");
        }
    }

    static void QueryData()
    {
        using (var connection = new SqliteConnection(connectionString))
        {
            connection.Open();
            
            var sql = "SELECT Id, Name, Email, Age FROM Users ORDER BY Age";
            
            var users = connection.Query<User>(sql).ToList();
            
            Console.WriteLine("\nСписок пользователей:");
            foreach (var user in users)
            {
                Console.WriteLine($"ID: {user.Id}, Имя: {user.Name}, Email: {user.Email}, Возраст: {user.Age}");
            }
        }
    }
}

public class User
{
    public int Id { get; set; }
    public string Name { get; set; } = string.Empty;
    public string Email { get; set; } = string.Empty;
    public int Age { get; set; }
}