DatabaseService.cs - master - weeny/database

DatabaseService.cs

67 строк2 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;
using System.Collections.Generic;

public class DatabaseService
{
    private readonly string _connectionString;

    public DatabaseService(string connectionString)
    {
        _connectionString = connectionString;
    }

    public IDbConnection CreateConnection()
    {
        return new SqliteConnection(_connectionString);
    }

    public List<T> Query<T>(string sql, object? parameters = null)
    {
        using (var connection = CreateConnection())
        {
            return connection.Query<T>(sql, parameters).ToList();
        }
    }

    public int Execute(string sql, object? parameters = null)
    {
        using (var connection = CreateConnection())
        {
            return connection.Execute(sql, parameters);
        }
    }

    public T? QueryFirstOrDefault<T>(string sql, object? parameters = null)
    {
        using (var connection = CreateConnection())
        {
            return connection.QueryFirstOrDefault<T>(sql, parameters);
        }
    }

    public void ExecuteTransaction(IEnumerable<string> commands)
    {
        using (var connection = CreateConnection())
        {
            connection.Open();
            using (var transaction = connection.BeginTransaction())
            {
                try
                {
                    foreach (var command in commands)
                    {
                        connection.Execute(command, transaction: transaction);
                    }
                    transaction.Commit();
                }
                catch
                {
                    transaction.Rollback();
                    throw;
                }
            }
        }
    }
}