C# (CSharp) xSqlBackUp Exemples

Exemple #1

        private async void button2_Click(object sender, EventArgs e)
        {
            var SSql = new xSqlBackUp();

            SSql.Open(@"Data Source=DESKTOP-B676VD8\SQLEXPRESS;Integrated Security=True;MultipleActiveResultSets=True", "facycred");

            AppendText("INICIANDO...");

            //string SecuenciasSql = File.ReadAllText(@"C:\Facycred_backups\20191116150609_respaldo.sql", Encoding.UTF8);

            //AppendText(SecuenciasSql);


            await SSql.Restore(@"C:\Facycred_backups\20191116150609_respaldo.sql");

            AppendText("CARGA REALIZADA!");
        }

Exemple #2

        private async void button1_Click(object sender, EventArgs e)
        {
            var SSql = new xSqlBackUp();

            SSql.Open(@"Data Source=DESKTOP-B676VD8\SQLEXPRESS;Integrated Security=True;MultipleActiveResultSets=True", "facycred");

            AppendText("INICIANDO...");


            await SSql.BackUp(@"C:\Users\PC\Desktop\resultados.sql");

            AppendText("RESPALDO REALIZADO!");



            //File.WriteAllText(, Respaldo);
        }

Exemple #3

        async void PrintCols(xSqlBackUp SSql)
        {
            SSql.SelectDb("facycred");
            var Listado = await SSql.GetColumns("xdd");

            foreach (ColumnInfo Col in Listado)
            {
                string str = string.Format(@"
------------------------------
PRIMARY KEY: {0}
COLUMNA: {1}
NULLABLE: {2}
TIPO DATO: {3}
MAXIMO LARGO: {4}

IDENTIDAD: {5}

------------------------------
", Col.IsPrimaryKey.ToString(), Col.Name, Col.NullAble.ToString(), Col.DataType, Col.MaxLength, Col.Identity != null ? "SI" : "NO");

                AppendText(str);
            }
        }