SqlOrmEntity.TrimConnect
1.1.8
dotnet add package SqlOrmEntity.TrimConnect --version 1.1.8
NuGet\Install-Package SqlOrmEntity.TrimConnect -Version 1.1.8
<PackageReference Include="SqlOrmEntity.TrimConnect" Version="1.1.8" />
paket add SqlOrmEntity.TrimConnect --version 1.1.8
#r "nuget: SqlOrmEntity.TrimConnect, 1.1.8"
// Install SqlOrmEntity.TrimConnect as a Cake Addin #addin nuget:?package=SqlOrmEntity.TrimConnect&version=1.1.8 // Install SqlOrmEntity.TrimConnect as a Cake Tool #tool nuget:?package=SqlOrmEntity.TrimConnect&version=1.1.8
// Class Created For TrimSql // Solid Task | Access DataBase | // Created On | 04/08/2016 11:27:34 AM // Latest Build | For Visual Studio 2017 // Aut Token | b7kkildsd52-88720-4wfe-8871-oljjk43455 // Version Update | V2.4.17 public class Keys : SqlOrmEntity.TrimConnectsql
{ public string MachineName; public Guid InstallationID; public string InstanceName; public int Client; public byte PublicKey; public byte SymmetricKey;
/// <summary>
/// Initializes a new instance of the <see cref="Keys"/> class.
/// </summary>
/// <param name="PrevID">The previous identifier.</param>
public Keys(int PrevID = 0) : base(PrevID)
{
}
/// <summary>
/// Procses the initilise.
/// pass 1 , optional param for encryption
/// </summary>
protected override void _ProcsInitilise()
{
ConnectionString = FetchConnectionString("jDB");
_InsertProceduer = "Insert_Keys";
_UpdateProceduer = "Update_Keys";
_deleteProceduer = "Delete_Keys";
_GetProceduer = "GetAll_Keys_ByID";
}
/// <summary>
/// Creates the schema parameters.
/// </summary>
/// <returns>IDataParameter[].</returns>
protected override IDataParameter[] CreateSchemaParams()
{
SqlParameter[] Sys_sp_Prms = {
new SqlParameter ("@MachineName",SqlDbType.NVarChar,512),
new SqlParameter ("@InstallationID",SqlDbType.UniqueIdentifier),
new SqlParameter ("@InstanceName",SqlDbType.NVarChar,64),
new SqlParameter ("@Client",SqlDbType.Int),
new SqlParameter ("@PublicKey",SqlDbType.Image,2147483647),
new SqlParameter ("@SymmetricKey",SqlDbType.Image,2147483647)};
Sys_sp_Prms[0].Value = MachineName;
Sys_sp_Prms[1].Value = InstallationID;
Sys_sp_Prms[2].Value = InstanceName;
Sys_sp_Prms[3].Value = Client;
Sys_sp_Prms[4].Value = PublicKey;
Sys_sp_Prms[5].Value = SymmetricKey;
return Sys_sp_Prms;
}
/// <summary>
/// Reads the data from Sql and push to DataLayer.
/// </summary>
protected override void _ReadData()
{
if (_PrevID == 0) return;
DataTable dt = RetrieveRowData(_PrevID);
if (dt.Rows.Count == 1)
{
MachineName = (string)dt.Rows[0]["MachineName"];
InstallationID = (Guid)dt.Rows[0]["InstallationID"];
InstanceName = (string)dt.Rows[0]["InstanceName"];
Client = (int)dt.Rows[0]["Client"];
PublicKey = (byte)dt.Rows[0]["PublicKey"];
SymmetricKey = (byte)dt.Rows[0]["SymmetricKey"];
}
else
{
_PrevID = 0;
}
}
}
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET Framework | net40 is compatible. net403 was computed. net45 was computed. net451 was computed. net452 was computed. net46 was computed. net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
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.
Latest Release to connect to Azure