LogicEntity 1.1.0
dotnet add package LogicEntity --version 1.1.0
NuGet\Install-Package LogicEntity -Version 1.1.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="LogicEntity" Version="1.1.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add LogicEntity --version 1.1.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: LogicEntity, 1.1.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.
// Install LogicEntity as a Cake Addin #addin nuget:?package=LogicEntity&version=1.1.0 // Install LogicEntity as a Cake Tool #tool nuget:?package=LogicEntity&version=1.1.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
LogicEntity
Build SQL and Execute
Linq To SQL
ORM
SQL Queries
Subqueries
Usage:
Same as IEnumerable.
Database:
var db = new MyDb("--connectionString--");
Select:
var data = db.Students.ToList();
Insert:
var rowsAffected = db.Students.Add(new Student()
{
Id = 1,
Name = "Name String",
MajorId = 3,
Json = new Student.JsonObject()
{
Object = new()
{
Property = "Insert Property Value"
}
}
});
Update:
var rowsAffected = db.Students.Where(s => s.Id == 1)
.Set
(
s => s.Float.Assign(5.5f),
s => ((Student.JsonObject)s.Json).Array[0].Assign(-5)
);
Delete:
var rowsAffected = db.Students.OrderByDescending(s => s.Id).Take(1).Remove();
Transaction:
db.ExecuteTransaction(transaction =>
{
try
{
var rowsAffected = db.Students.OrderByDescending(s => s.Id).Take(1).Remove();
transaction.Commit();
}
catch
{
transaction.Rollback();
}
}, IsolationLevel.ReadCommitted);
SQL:
var data = db.Query<Student>("Select studentId + {0} As Id From Student Limit 10", 1).ToList();
CTE:
var data = db.Value(() => new { n = 1 }).RecursiveConcat(ns => ns.Where(s => s.n < 20).Select(s => new { n = s.n + 1 })).Take(20).ToList();
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net7.0 is compatible. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. 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. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net7.0
- No dependencies.
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.