Cchsille.Any.Database 1.1.0

How to use

Descriptions

AnyDatabase.SQLite.SQLiteAccessor is a class that provides an easy way to access SQLite databases. It supports both synchronous and asynchronous operations, allowing you to execute SQL commands and queries with or without parameters.

This project is use Microsoft.Data.Sqlite as a database driver, which is a lightweight and efficient library for SQLite database access in .NET applications.

Code Example

▼ MyDatabase.cs

using System.Text;
using AnyDatabase.SQLite;
using ReadMe.Database.Entity;

namespace ReadMe.Database;

internal class MyDatabase : IDisposable
{
    private readonly SQLiteAccessor _accessor;


    private MyDatabase(string filePath, string password)
    {
        _accessor = new SQLiteAccessor(filePath, password);
    }

    public static MyDatabase Open()
    {
        var instance = new MyDatabase("MyDatabase.db", "Pass1234");
        instance._accessor.Open();
        return instance;
    }

    public IReadOnlyList<User> GetUser(string userId)
    {
        var sb = new StringBuilder();
        sb.AppendLine("SELECT C_USER_ID ");
        sb.AppendLine("      ,C_USER_NAME ");
        sb.AppendLine("      ,C_MAIL_ADDRESS ");
        sb.AppendLine("  FROM M_USER ");
        sb.AppendLine(" WHERE C_USER_ID = $UserId ");

        var param = new SQLiteBindParameter();
        param.SetBindData("$UserId", userId);

        return _accessor.ExecuteReader<User>(sb.ToString(), param);
    }

    public bool InsertUser(User user)
    {
        var sb = new StringBuilder();
        sb.AppendLine("INSERT INTO M_USER ");
        sb.AppendLine("( ");
        sb.AppendLine("    C_USER_ID ");
        sb.AppendLine("   ,C_USER_NAME ");
        sb.AppendLine("   ,C_MAIL_ADDRESS ");
        sb.AppendLine(") ");
        sb.AppendLine("VALUES ");
        sb.AppendLine("( ");
        sb.AppendLine("    $UserId ");
        sb.AppendLine("   ,$UserName ");
        sb.AppendLine("   ,$MailAddress ");
        sb.AppendLine(") ");

        var param = new SQLiteBindParameter();
        param.SetBindData("$UserId", user.UserId);
        param.SetBindData("$UserName", user.UserName);
        param.SetBindData("$MailAddress", user.MailAddress);

        return _accessor.ExecuteNonQuery(sb.ToString(), param) > 0;
    }


    protected virtual void Dispose(bool disposing)
    {
        if (disposing)
        {
            _accessor.Dispose();
        }
    }

    public void Dispose()
    {
        Dispose(true);
        GC.SuppressFinalize(this);
    }
}

▼ User.cs

using AnyDatabase;

namespace ReadMe.Database.Entity;

internal class User
{
    [Column("C_USER_ID")]
    public string? UserId { get; set; }

    [Column("C_USER_NAME")]
    public string? UserName { get; set; }

    [Column("C_MAIL_ADDRESS")]
    public string? MailAddress { get; set; }
}