How to execute an .SQL script file using C#

If you need to execute TSQL script inside C# code using only standard libs then you can use this.

FileInfo file = new FileInfo(@"E:\someSqlScript.sql");
string script = file.OpenText().ReadToEnd();


  // split script on GO command
  IEnumerable<string> commandStrings = Regex.Split( script, "^\\s*GO\\s*$", RegexOptions.Multiline );

  Connection.Open();
  foreach( string commandString in commandStrings )
  {
    if( commandString.Trim() != "" )
    {
      new SqlCommand( commandString, Connection ).ExecuteNonQuery();
    }
  }     
  Connection.Close();

Generate random number in Oracle

Sometimes you need unique random number. Here is code for PL/SQL

FUNCTION GetRandNumber RETURN Number IS

 l_seed BINARY_INTEGER;
 l_random_num NUMBER(5);
 l_date VARCHAR2(25);
 l_random VARCHAR2(4);

BEGIN
  l_seed := TO_NUMBER(TO_CHAR(SYSTIMESTAMP, 'FF'));
  DBMS_RANDOM.initialize (val => l_seed);
  l_random_num := TRUNC(DBMS_RANDOM.value(low => 1, high => 65535));
  DBMS_RANDOM.terminate;
  return l_random_num;


END GetRandNumber;