omansak

/*
______________________________________________________________________
| 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        |

omansak

    public class PasswordHasher
    {
        /// <summary>
        /// Size of salt.
        /// </summary>
        private const int SaltSize = 16;

        /// <summary>
        /// Size of hash.
        /// </summary>

omansak

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
(

omansak

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
{

omansak

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;


public class Program
{
    static void Main(string[] args)