View oracle-generate-class-from-table.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
______________________________________________________________________ | |
| ORACLE DATABASE DATA TYPE | NET TYPE ALIAS | NETDATATYPE | | |
|----------------------------|----------------|----------------------| | |
| NUMBER1 | BOOL | SYSTEM.BOOLEAN | | |
| NUMBER2TONUMBER4 | BYTE | SYSTEM.BYTE | | |
| NUMBER5 | SHORTINT16 | SYSTEM.INT16 | | |
| NUMBER6TONUMBER10 | INTINT32 | SYSTEM.INT32 | | |
| NUMBER11TONUMBER19 | LONGINT64 | SYSTEM.INT64 | | |
| NUMBERGT19 | DECIMAL | SYSTEM.DECIMAL | |
View net-core-password-hash.cs
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
public class PasswordHasher | |
{ | |
/// <summary> | |
/// Size of salt. | |
/// </summary> | |
private const int SaltSize = 16; | |
/// <summary> | |
/// Size of hash. | |
/// </summary> |
View sqlserver-generate-class-from-table.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
declare @TableName sysname = 'LOGIN' | |
declare @Result varchar(max) ='[Table("'+@TableName+'")]' +' | |
public class ' + @TableName + ' | |
{' | |
select @Result = @Result + ' [Column("'+ replace(ColumnName, ' ', '_') +'")]' +' | |
public ' + ColumnType + NullableSign + ' ' + ColumnName + ' { get; set; } | |
' | |
from | |
( |
View OracleQueryBuilder.cs
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
using Oracle.ManagedDataAccess.Client; | |
using System; | |
using System.Collections.Generic; | |
using System.Data; | |
using System.Diagnostics; | |
using System.Linq; | |
using System.Text; | |
namespace MSU.Recourse.Extensions | |
{ |
View ValueReferenceType.cs
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
using System; | |
using System.Collections.Generic; | |
using System.IO; | |
using System.Linq; | |
using System.Text; | |
public class Program | |
{ | |
static void Main(string[] args) |