SDKDataLayer 1.0.0
dotnet add package SDKDataLayer --version 1.0.0
NuGet\Install-Package SDKDataLayer -Version 1.0.0
<PackageReference Include="SDKDataLayer" Version="1.0.0" />
paket add SDKDataLayer --version 1.0.0
#r "nuget: SDKDataLayer, 1.0.0"
// Install SDKDataLayer as a Cake Addin
#addin nuget:?package=SDKDataLayer&version=1.0.0
// Install SDKDataLayer as a Cake Tool
#tool nuget:?package=SDKDataLayer&version=1.0.0
SDK Data Access System helps to communicate SQL Server Database with Umbraco or MVC using stored procedure
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET Framework | net is compatible. |
This package has no dependencies.
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
1.0.0 | 1,428 | 4/8/2016 |
Release notes for SDK Data Access
SDK Data Access Layer supports the following 9 methods to communicate with your data base, you just need to pass your connection string to the SDK Datalayer, it will return you the objects you are passing from your class
Data Repository class:
This method will help you to return a data of string, integer, date or decimal from the database without passing an object. In order to return the specified data type please pass the following values
GenericDataLayer.Enums.ReturnDataType.stringValue
GenericDataLayer.Enums.ReturnDataType.datetimeValue
GenericDataLayer.Enums.ReturnDataType.integerValue
GenericDataLayer.Enums.ReturnDataType.decimalValue
Methods
1.Method name: GetItem
Parameters: stored procedure name
How to use:
GenericDataLayer.DataAbstractClass myOBject = new DataRepository(GenericDataLayer.Enums.ReturnDataType.stringValue, "SQLConnection-String");
myOBject.GetItem("[GetItemsstring]");
var objectList = myOBject.returnValue;
2. method name: GetItem
Parameters: stored procedure name, dictionary of parameter and its values
How to use:
GenericDataLayer.DataAbstractClass myOBject = new DataRepository(GenericDataLayer.Enums.ReturnDataType.stringValue, "SQLConnection-String");
myOBject.GetItem("your proceudrue name", new Dictionary<string, string>() { { "parameter", "value" });
var objectList = myOBject.returnValue;
3. method name: GetItem
Parameters: stored procedure name, array of parameters value
How to use:
GenericDataLayer.DataAbstractClass myOBject = new DataRepository(GenericDataLayer.Enums.ReturnDataType.stringValue, "SQLConnection-String");
myOBject.GetItem("your proceudrue name", new string[] { "test" } );
var objectList = myOBject.returnValue;
===================================================================================================================================================
DataExecuteRepository class
This method will help you to execute a stored procedure
methods
1.method name: ExecuteCommandWithReturnParameter
Parameters: stored procedure name, dictionary of parameter and its values,output parameter name
How to use
DataExecuteAbstractClass dataAbstractClass = new DataExecuteRepository("your connnection string here"); //
dataAbstractClass.ExecuteCommandWithReturnParameter("your proceudrue name", new Dictionary<string, string>() { { "parameter", "value" } }, "output parameter name");
var testvalue= dataAbstractClass.stringValue;
2. method name: ExecuteCommandWithoutReturnParameter
Parameters: stored procedure name, dictionary of parameters and its value
How to use
DataExecuteAbstractClass dataAbstractClass = new DataExecuteRepository("your connnection string here"); //
dataAbstractClass.ExecuteCommandWithReturnParameter("your proceudrue name", new Dictionary<string, string>() { { "parameter", "value" } });
3. method name: ExecuteCommandWithoutReturnParameter
Parameters: stored procedure name, array of parameters value
How to use
DataExecuteAbstractClass dataAbstractClass = new DataExecuteRepository("your connnection string here"); //
dataAbstractClass.ExecuteCommandWithoutReturnParameter("your proceudrue name", new string[] { "test" } });
===========================================================================================================================================================
DataObjectRepository class
This method will help you to return a custom object list from a stored procedure
methods
1.method name: GetItem
Parameters: stored procedure name
How to use:
GenericDataLayer.DataObjectAbstractClass<your object> myOBject = new DataObjectRepository<your object>("your connection string");
myOBject.GetItemList("GetItemsbynameLike");
var objectList = myOBject.ItemList;
2. method name: GetItem
Parameters: stored procedure name, dictionary of parameters and its value
How to use:
GenericDataLayer.DataObjectAbstractClass<your object> myOBject = new DataObjectRepository<your object>("your connection string");
myOBject.GetItemList("GetItemsbynameLike", new Dictionary<string, string>(){ { "itemname", "test" }});
var objectList = myOBject.ItemList;
3. method name: GetItem
Parameters: stored procedure name, array of parameters value
How to use:
GenericDataLayer.DataObjectAbstractClass<your object> myOBject = new DataObjectRepository<your object>("your connection string");
myOBject.GetItemList("GetItemsbynameLike", new string[] { "test" });
var objectList = myOBject.ItemList;