Skip to content

Latest commit

 

History

History
35 lines (26 loc) · 1.1 KB

README.md

File metadata and controls

35 lines (26 loc) · 1.1 KB

sql-data-api-client-dotNet

.Net Core client for Sql Data Api. Sql Data Api is RESTApi on top of SQL Server database. Server Side is available as part of Low Code Data Management Platform - Worksheet Systems (https://worksheet.systems)

Usage

	// set base url and authentication
	SqlDataApi.SetBaseUrl("https://localhost:44302");
	SqlDataApi.SetAuthentication("*****");
	
	var TestConnectionName = "SQL-Shared"

	// select [List of fields taken from SimpleObject] from test1.Sample100 where Country = 'UK'	
	var items = SqlDataApi
		.Create(TestConnectionName)
		.Table("test1.Sample100")
		.Filter("Country = @country", new { country = "UK" })
		.RunQuery<SimpleObject>();

	items[0].OrderQuantity = items[0].OrderQuantity + 10;
	
	// merge modified collection to the table	
	var status = SqlDataApi
		.Create(TestConnectionName)
		.Table("test1.Sample100")
		.Save(items);

Tests

More examples can be found in tests https://github.com/FalconSoft/sql-data-api-client-dotNet/blob/main/src/FalconSoft.SqlDataApi.Client.Tests/SqlData.Client.Tests.cs

License

A permissive MIT License (c) FalconSoft Ltd.