RepoDb - a hybrid ORM library for .NET.

#csharp #dotnet #sql #orm

Introduction

Introducing RepoDb, a new high performant and efficient hybrid ORM library for .NET.

To begin with, you can start reading our Getting Started page or learn more from our documentation.

Why use RepoDb? Your benefits!

Easy installation, only takes few seconds.
No controlled layer like DbContext, those make the developers speed-up the usability.
Calls to Fluent and Raw-SQL methods is just a dot away.
Repository implementation becomes more simpler by leveraging the built-in repositories.
Can work without the models; everything can be dynamics.
Ease of pain when working with large data sets.
Minimizes the round trips with 2nd-Layer cache.
Transmission of data from different RDBMS DB Providers only take few lines of codes.

How does it works?

Basically, all operations were implemented as extended methods of the IDbConnection object. Once you hold the opened-state of your database connection object, you can then do all the activities you would like to do with your database through those extended methods.

See sample code snippets below:

For Query.

using (var connection = new SqlConnection(ConnectionString))
{
    var customer= connection.Query<Customer>(10045).FirstOrDefault();
}

For Insert.

using (var connection = new SqlConnection(ConnectionString))
{
    var customer = new Customer
    {
        Name = "John Doe",
        Address = "New York"
    };
    var id = connection.Insert<Customer>(customer);
}

For Update.

using (var connection = new SqlConnection(ConnectionString))
{
    var customer = new Customer
    {
        Id = 10045,
        Name = "Jane Doe",
        Address = "Chicago"
    };
    var rowsAffected = connection.Update<Customer>(customer);
}

And for Delete.

using (var connection = new SqlConnection(ConnectionString))
{
    var deletedRows = connection.Delete<Customer>(10045);
}

You can also execute a Raw SQLs via Execute methods (ie: ExecuteQuery, ExecuteNonQuery, ExecuteScalar and ExecuteReader).

using (var connection = new SqlConnection(ConnectionString))
{
    var customers = connection.ExecuteQuery<Customer>("SELECT * FROM [dbo].[Customer];");
}

Or even executing a StoredProcedure.

using (var connection = new SqlConnection(ConnectionString))
{
    var customers = connection.ExecuteQuery<Customer>("sp_GetCustomersByState", new { State = "New York" }, commandType: CommandType.StoredProcedure);
}