DotNetHelper.ObjectToSql takes your generic types or dynamic & anonymous objects and convert it to sql.
|| Documentation • API • Tutorials || Change Log • || View on Github||
AppVeyor | AzureDevOps |
---|---|
Package | Tests | Code Coverage |
---|---|---|
- Generating the following sqls from objects & datatables
- INSERT
- UPDATE
- DELETE
- UPSERT
- Supports SQLServer OUTPUT CLAUSE Using Expressions
- Create DBParameters from any type of objects
- SQLSERVER
- SQLITE
- MYSQL
- More to come
public class Employee {
public FirstName { get; set; }
public LastName { get; set; }
}
var insertSql = new ObjectToSql(DataBaseType.SqlServer).BuildQuery<Employee>(ActionType.Insert);
// OR USING EMPLOYEE OBJECT
var insertSql = new ObjectToSql(DataBaseType.SqlServer).BuildQuery(ActionType.Insert,new Employee());
dynamic record = new ExpandoObject();
record.FirstName = "John";
record.LastName = "Doe";
var insertSql = new ObjectToSql(DataBaseType.SqlServer).BuildQuery(ActionType.Insert, record, "Employee");
var obj = new {FirstName = "John", LastName = "Doe"};
var insertSql = new ObjectToSql(DataBaseType.SqlServer).BuildQuery(ActionType.Insert, obj, "Employee");
var insertSql = new DataTableToSql(DataBaseType.SqlServer).BuildQuery(dataTable, ActionType.Insert);
INSERT INTO Employee ([FirstName],[LastName]) VALUES (@FirstName,@LastName)
var obj2Sql = new ObjectToSql(DataBaseType.SqlServer);
var dbParameters = obj2Sql.BuildDbParameterList(new Employee(), (s, o) => new SqlParameter(s, o));
Unit Test are performed against live instance of databases running via docker containers Make sure you spin up the container via database.ps1
For more information, please refer to the Officials Docs