LazySqlStandard.Engine 2.1.1-preview

LazySql

LazySql is a micro ORM to simplify the interfacing between an application and a Sql Server Database.

Whats new in 2.1.1-preview?

• System.Data.SqlClient from 4.8.4 to 4.8.5 (Security)
• Support of object and dynamic types!
• Namespace fixed
• Support of SqlCredential

Packages

NuGet	Downloads	.NET	.NET Framework	.NET Standard	Sql Server
		6.0	4.8	2.0	> Sql Server 2012

How to use it?

First of all, the initialization

LazySql uses a singleton, so you only have to initialise the client once.

LazyClient.Initialize("Server=my-server\SQL2019;Database=MyDataBase;");

Select all the data in a table

foreach (Car car in LazyClient.Select<Car>()) {
   Console.WriteLine(car.Name);
}

Select some data in a table with Expression (WHERE)

foreach (Car car in LazyClient.Select<Car>().Where(c=>c.Country == "FR" && c.Enabled).OrderBy(c=>c.Name)) {
   Console.WriteLine(car.Name);
}

This automatically generates the following SQL query in the background:

SELECT Id, Name, ... FROM Cars WHERE Country = 'FR' AND Enabled = 1 ORDER BY Name

Update in database

If your object is derived from LazyBase, you can easily update it:

Car car = new Car() {Id = 1, Name = "Second Car"};
car.Update();

This will generate the following SQL query:

UPDATE Cars SET Name = 'Second Car' WHERE id = 1

Update multiple rows in database

Car updateCar = new Car() {Name = "New Name"};
LazyClient.Update<Car>(updateCar, c=>c.Name == null || Id = 0);

This will generate the following SQL query:

UPDATE Cars SET Name = 'New Name' WHERE Name IS NULL OR Id = 0

Delete in database

If your object is derived from LazyBase, you can easily delete it:

Car car = new Car() {Id = 1};
car.Delete();

This will generate will generate the following SQL query:

DELETE Cars WHERE id = 1

Delete multiple rows in database

LazyClient.Delete<Car>(c=>!c.Enabled);

This will generate will generate the following SQL query:

DELETE Cars WHERE Enabled = 0

And more...

Stored Procedure

StoredProcedureResult result = LazyClient.StoredProcedure("my_procedure",
            new SqlArguments()
               .Add("@FirstName", SqlType.NVarChar, "Florian")
               .Add("@Age", SqlType.Int, 40)
               .AddOut("@Id", SqlType.Int) // OUTPUT PARAMETER
        );

// Get return value (RETURN)
Console.WriteLine($"Result: {result.ReturnValue}");
// Get Output value
Console.WriteLine($"Result: {result.Output.Id}");

// Get first table with dynamic types
IEnumerable<dynamic> dynamicValues = result.Tables[0].Parse();
// Get second table with an object type
IEnumerable<Profil> result.Tables[1].Parse<Profil>();

Bulk Insert

List<Car> cars = GetCars();
LazyClient.BulkInsert(cars);

ExecuteNonQuery method

int affectedRows = LazyClient.ExecuteNonQuery("DELETE FROM web_users");

ExecuteScalar method

string firstName = LazyClient.ExecuteNonQuery<string>("SELECT firstname FROM web_users WHERE Id = @Id", new SqlArgument("@Id", SqlType.Int, 50));

Documentation

Click here for the full documentation, F.A.Q. and Release Note !

License

LazySql is licensed under the terms of the MIT license and is available for free.

Links

• My Web site: https://floriandussault.dev/
• Documentation: https://lazysql.floriandussault.dev/