SDKDataLayer 1.0.0

.NET Framework This package is compatible with all versions of .NET Framework. 
dotnet add package SDKDataLayer --version 1.0.0
NuGet\Install-Package SDKDataLayer -Version 1.0.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="SDKDataLayer" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add SDKDataLayer --version 1.0.0
#r "nuget: SDKDataLayer, 1.0.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// 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 Compatible and additional computed target framework versions.
.NET Framework net is compatible. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

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;