C# (CSharp) SqlProcess Beispiele

Beispiel #1

        void IInstallAction.Run(SetupVariables vars)
        {
            try
            {
                var component   = vars.ComponentFullName;
                var componentId = vars.ComponentId;

                var path = Path.Combine(vars.InstallationFolder, SqlFilePath);

                if (!FileUtils.FileExists(path))
                {
                    Log.WriteInfo(String.Format("File {0} not found", path));
                    return;
                }
                //
                SqlProcess process = new SqlProcess(path, vars.DbInstallConnectionString, vars.Database);
                //
                process.ProgressChange += new EventHandler <ActionProgressEventArgs <int> >(process_ProgressChange);
                //
                process.Run();
                //
                InstallLog.AppendLine(string.Format("- Installed {0} database objects", component));
            }
            catch (Exception ex)
            {
                if (Utils.IsThreadAbortException(ex))
                {
                    return;
                }
                //
                Log.WriteError("Run sql error", ex);
                //
                throw;
            }
        }

Beispiel #2

Datei: EntServerActionManager.cs Projekt: jordan49/websitepanel

		void IInstallAction.Run(SetupVariables vars)
		{
			try
			{
				var component = vars.ComponentFullName;
				var componentId = vars.ComponentId;

				var path = Path.Combine(vars.InstallationFolder, SqlFilePath);

				if (!FileUtils.FileExists(path))
				{
					Log.WriteInfo(String.Format("File {0} not found", path));
					return;
				}
				//
				SqlProcess process = new SqlProcess(path, vars.DbInstallConnectionString, vars.Database);
				//
				process.ProgressChange += new EventHandler<ActionProgressEventArgs<int>>(process_ProgressChange);
				//
				process.Run();
				//
				InstallLog.AppendLine(string.Format("- Installed {0} database objects", component));
			}
			catch (Exception ex)
			{
				if (Utils.IsThreadAbortException(ex))
					return;
				//
				Log.WriteError("Run sql error", ex);
				//
				throw;
			}
		}

Beispiel #3

Datei: Adapter.cs Projekt: lwhitelock/Websitepanel

        /// <summary>
        /// Runs sql script.
        /// </summary>
        /// <param name="connectionString">Sql server connection string.</param>
        /// <param name="database">Sql server database name.</param>
        /// <param name="fileName">Sql script file</param>
        private void RunSqlScript(string connectionString, string database, string fileName)
        {
            if (!File.Exists(fileName))
            {
                Log.WriteInfo(string.Format("File {0} not found", fileName));
                return;
            }

            Log.WriteStart("Installing database objects");

            //showing process
            SqlProcess process = new SqlProcess(fileName, connectionString, database);
            // Update progress change
            process.ProgressChange += new EventHandler<ActionProgressEventArgs<int>>((object sender, ActionProgressEventArgs<int> e) =>
            {
                //this.progressBar.Value = e.EventData;
                this.SetProgressValue(e.EventData);
            });
            //
            process.Run();

            Log.WriteEnd("Installed database objects");
        }