Exemplos de ISqlConnectionProvider.ObtenerInstanciaSqlConnection em C# (CSharp)

Exemplo n.º 1

        public string GenerarBackup(string backupQuery)
        {
            SqlConnection cn = sqlConnectionInstance.ObtenerInstanciaSqlConnection(connectionStringSettings["DefaultConnection"].ConnectionString);

            string database = cn.Database;

            try
            {
                using (SqlCommand command = new SqlCommand(backupQuery, cn))
                {
                    if (cn.State != ConnectionState.Open)
                    {
                        cn.Open();
                    }

                    command.ExecuteNonQuery();
                    cn.Close();

                    return("OK");
                }
            }
            catch (Exception ex)
            {
                return(ex.Message);
            }
        }