{"repo":"Open-NET-Libraries/Open.Database.Extensions","free":true,"listed":false,"github":"https://github.com/Open-NET-Libraries/Open.Database.Extensions","clone":"git clone https://github.com/Open-NET-Libraries/Open.Database.Extensions.git","description":"Useful set of utilities and abstractions for simplifying modern data-access operations and ensuring DI compatibility.","language":"C#","stars":24,"topics":["csharp","dotnet","database","extensions","sqlclient","asynchronous","expressive","ado","async-await","data-flow"],"license":"MIT","category":"databases-storage","readme_excerpt":"Open.Database.Extensions Useful set of utilities and abstractions for simplifying modern database operations and ensuring dependency injection compatibility. Principles - Minimize connection open time. - Deferred/lazy transformation. - Optimize for specific use cases. - Minimize boilerplate code. Features - Provides a fluent interface for database operations. - Supports dependency injection for connection factories. - Support both synchronous and asynchronous operations. - Provides expressive commands for executing SQL queries and stored procedures. Connection Factories Connection factories facilitate creation and disposal of connections without the concern of a connection reference or need for awareness of a connection string. A SqlConnectionFactory is provided and can be overridden to provide more specific dependency injection configurations. Expressive Commands The provided expressive command classes allow for an expressive means to append parameters and execute the results without lengthy complicated setup. Extensions are provided to create commands from connection factories. Example Extensions Instead of writing this: Is now simplified to this: Deferred Transformation In order to keep connection open time to a minimum, some methods cache data before closing the connection and then subsequently applying the transformations as needed. Results () and ResultsAsync () Queues all the data. Then using the provided type T entity, the data is coerced by which properties intersect","default_branch":null,"files":null,"tree":[],"storefront":"/r/Open-NET-Libraries","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Open-NET-Libraries/Open.Database.Extensions/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}