public string ReadSQLFile(string tempUnzippedPath, string sqlProvidername) { string exceptions = string.Empty; try { StreamReader objReader = new StreamReader(tempUnzippedPath + '\\' + sqlProvidername); string sLine = ""; string scriptDetails = ""; ArrayList arrText = new ArrayList(); while (sLine != null) { sLine = objReader.ReadLine(); if (sLine != null) { arrText.Add(sLine); } } objReader.Close(); foreach (string sOutput in arrText) { scriptDetails += sOutput + "\r\n"; } OracleHandler sqlHandler = new OracleHandler(); exceptions = sqlHandler.ExecuteScript(scriptDetails, true); } catch (Exception ex) { exceptions += ex.Message.ToString(); } return(exceptions); }