LtQuery 1.3.0

.NET 8.0 This package targets .NET 8.0. The package is compatible with this framework or higher. 
dotnet add package LtQuery --version 1.3.0
                    


                    

                
NuGet\Install-Package LtQuery -Version 1.3.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="LtQuery" Version="1.3.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="LtQuery" Version="1.3.0" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="LtQuery" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add LtQuery --version 1.3.0
                    


                    

                
#r "nuget: LtQuery, 1.3.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
#:package LtQuery@1.3.0
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=LtQuery&version=1.3.0
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=LtQuery&version=1.3.0
                    


                            Install as a Cake Tool

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
Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

  • net8.0

    • No dependencies.

NuGet packages (2)

Showing the top 2 NuGet packages that depend on LtQuery:

Package Downloads
LtQuery.Relational

a high performance mapper for .Net
LtQuery.Sql

a high performance mapper for .Net

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
1.3.0 162 6/16/2025
1.2.2 319 12/11/2023
1.2.1 232 12/8/2023
1.2.0 189 12/6/2023
1.1.1 217 12/3/2023
1.1.0 212 12/3/2023
1.0.4 217 12/1/2023
1.0.3 211 11/30/2023
1.0.2 206 11/29/2023
1.0.1 222 11/29/2023
1.0.0 201 11/27/2023
0.5.3 195 11/25/2023
0.5.2 196 11/25/2023
0.5.1 187 11/25/2023
0.4.0 187 11/18/2023
0.3.2 187 11/17/2023
0.3.1 177 11/16/2023
0.3.0 182 11/8/2023
0.2.1 176 11/4/2023
0.2.0 173 11/1/2023