Activity of sebastienros/yessql repository

Active 🚀

Active contributions

Why sebastienros/yessql is active?

The result is based on ratio of number of commits and code additions from initial and final time ranges.

Initial time range – from 5 Jul, 2023 to 5 Oct, 2023

Final time range – from 5 Apr, 2024 to 5 Jul, 2024

Additions and deletions stats are not available for this repository due to GitHub API limitations.

Data calculated on 5 Jul, 2024

Summary of sebastienros/yessql

The sebastienros/yessql GitHub repository is a .NET library designed to provide a lightweight, easy-to-use interface for working with relational databases. It abstracts away much of the complexity of directly interacting with SQL databases, letting developers work with .NET objects instead.

With YesSql, you can use LINQ queries to interact with the database and the library will automatically handle converting these queries into the appropriate SQL commands. By doing so, it streamlines the process of working with data in a SQL database.

Features include:

Stores .NET objects into any RDBMS without any modifications required to the class definition
Utilizes Document database techniques for simplifying horizontal scalability
Supports transactions
Provides full-text search

Majority of the SQL databases are supported by YesSql which includes:

SQLite
MySql
PostgreSql
SQL Server

YesSQL is used as a storage engine by the Orchard Core project,and it also supports both Asp.Net and .Net Core.

YesSQL is open-source and contributions are welcomed. It is licensed under the Apache-2.0 License.

Below is a code example of how you can use YesSql:

using (var session = _store.CreateSession())
{
    var persons = new List<Person>
    {
        new Person { Firstname = \"Bill\", Lastname = \"Gates\" },
        new Person { Firstname = \"Steve\", Lastname = \"Balmer\" }
    };

    foreach(var person in persons)
    {
        await session.Save(person);
    }

    await session.CommitAsync();
}

using (var session = _store.CreateSession())
{
    var persons = await session.Query<Person, PersonIndex>(x => x.Lastname.StartsWith(\"B\")).ListAsync();

    foreach(var person in persons)
    {
        Console.WriteLine($\"{person.Firstname} {person.Lastname}\");
    }
}