RepoDB

RepoDB is an open-source .NET library that bridges the gap between high-level ORMs like Entity Framework and low-level data access approaches such as Dapper. It aims to provide a balance between flexibility, performance, and simplicity, offering a fluent and intuitive interface for performing database operations.

• Performance: RepoDB offers near Dapper-like performance by minimizing overhead while providing a higher abstraction.

• Simplicity: It provides a fluent API that is easy to understand and use.

• Flexibility: RepoDB supports multiple databases and can be used with various ADO.NET providers.

• Control: It gives you the flexibility to write SQL queries when needed while leveraging the power of a higher-level abstraction.

1. Install RepoDB: You can install RepoDB via NuGet Package Manager or the Package Manager Console:

   Install-Package RepoDb

2. Set Up the Model: Define your data model, e.g., BlogModel.

3. Implement Database Operations: Use RepoDB's methods to interact with the database.

Example with RepoDB

BlogModel.cs

public class BlogModel
{
    public int BlogId { get; set; }
    public string BlogTitle { get; set; }
    public string BlogAuthor { get; set; }
    public string BlogContent { get; set; }
}

RepoDB Example

1. Constructor

public class RepoDbExample
{
    private readonly IDbConnection _dbConnection;

    public RepoDbExample(IDbConnection dbConnection)
    {
        _dbConnection = dbConnection;
        // Initialize RepoDB
        RepoDb.SqlServerBootstrap.Initialize();
    }
}

Summary: The constructor initializes the class with an IDbConnection object and sets up RepoDB for SQL Server.

1. Read Method

public void Read()
{
    var blogs = _dbConnection.QueryAll<BlogModel>().ToList();

    foreach (var blog in blogs)
    {
        Console.WriteLine($"Blog Id => {blog.BlogId}");
        Console.WriteLine($"Blog Title => {blog.BlogTitle}");
        Console.WriteLine($"Blog Author => {blog.BlogAuthor}");
        Console.WriteLine($"Blog Content => {blog.BlogContent}");
        Console.WriteLine("--------------------------------");
    }
}

Summary: This method retrieves all rows from the BlogModel table, converts the results to a list of BlogModel objects, and prints each blog's data to the console.

1. Edit Method

public void Edit(int id)
{
    var blog = _dbConnection.Query<BlogModel>(id).FirstOrDefault();

    if (blog == null)
    {
        Console.WriteLine("No data found.");
        return;
    }

    Console.WriteLine($"Blog Id => {blog.BlogId}");
    Console.WriteLine($"Blog Title => {blog.BlogTitle}");
    Console.WriteLine($"Blog Author => {blog.BlogAuthor}");
    Console.WriteLine($"Blog Content => {blog.BlogContent}");
}

Summary: This method retrieves a specific blog entry based on the provided ID, prints the details if found, or indicates that no data was found.

1. Create Method

public void Create(string title, string author, string content)
{
    var blog = new BlogModel
    {
        BlogTitle = title,
        BlogAuthor = author,
        BlogContent = content
    };

    var result = _dbConnection.Insert<BlogModel, int>(blog);

    Console.WriteLine(result > 0 ? "Saving Successful." : "Saving Failed.");
}

Summary: This method inserts a new blog entry into the BlogModel table with the provided title, author, and content, and indicates whether the save operation was successful.

1. Update Method

public void Update(int id, string title, string author, string content)
{
    var blog = new BlogModel
    {
        BlogId = id,
        BlogTitle = title,
        BlogAuthor = author,
        BlogContent = content
    };

    var result = _dbConnection.Update(blog);

    Console.WriteLine(result > 0 ? "Updating Successful." : "Updating Failed.");
}

Summary: This method updates an existing blog entry in the BlogModel table based on the provided ID, title, author, and content, and indicates whether the update operation was successful.

1. Delete Method

public void Delete(int id)
{
    var result = _dbConnection.Delete<BlogModel>(id);

    Console.WriteLine(result > 0 ? "Deleting Successful." : "Deleting Failed.");
}

Summary: This method deletes a blog entry from the BlogModel table based on the provided ID, and indicates whether the delete operation was successful.

Summary: By using RepoDB, you can simplify database operations while maintaining readability and performance. It provides a balance between raw SQL performance and higher-level ORM abstractions, making your code more concise and easier to maintain.

This approach allows you to harness the power and flexibility of RepoDB for efficient and straightforward database interactions.