LtQuery 1.2.2

LtQuery

About

LtQuery is a ORM focus on Easy-to-use and high performance

LtQuery does not accept the input of SQL which is a string. Instead, call giving a diverty, tiny query object.

How to Use

// setup DI Container
var collection = new ServiceCollection();
collection.AddLtQuerySqlServer(new ModelConfiguration(), _ => new SqlConnection(/*ConnectionString*/));
var provider = collection.BuildServiceProvider();

using(var scope = provider.CreateScope())
{
	// get ILtConnection
	var connection = scope.ServiceProvider.GetRequiredService<ILtConnection>();

	// create query object
	var query = Lt.Query<Blog>()
		.Include(_ => _.Posts)
		.Where(_ => _.UserId == Lt.Arg<int>("UserId"))
		.OrderBy(_ => _.Date).Take(20);

	// execute query
	var blogs = connection.Select(query, new { UserId = 5 });

	// Write using Unit of Work
	using (var unitOfWork = connection.CreateUnitOfWork())
	{
		var blog = blogs[0];
		blog.Title = "NewTitle";
		unitOfWork.Update(blog);

		// Write
		unitOfWork.Commit();
	}
}

Install

Case using SQL Server.

dotnet add package LtQuery.SqlServer

Case using MySQL/MariaDB.

dotnet add package LtQuery.MySql

Case using SQLite.

dotnet add package LtQuery.Sqlite