LazySqlStandard.Engine 2.0.0-preview

LazySql

LazySql is a micro ORM to simplify the interfacing between an application and a database.

⭐ Star me on GitHub — it motivates me a lot!

Compatibility

.NET

Sql Server

Minimum version: 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);
}

This automatically generates the following SQL query in the background:

SELECT Id, Name, ... FROM Cars

Select some data in a table (with Expression)

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();

Or (if your object doesn't derive from LazyBase):

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

These two methods will generate the following SQL query:

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

Delete in database

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

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

Or (if your object doesn't derive from LazyBase):

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

These two methods will generate the following SQL query:

DELETE Cars WHERE id = 1

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/