EF5批量操作数据库（批量创建、删除、附加、分离、脱机、联机）

最新推荐文章于 2025-05-24 09:38:28 发布

原创最新推荐文章于 2025-05-24 09:38:28 发布 · 2k 阅读

0 ·

CC 4.0 BY-SA版权

Entity Framework 专栏收录该内容

4 篇文章

订阅专栏

本教程详细介绍了使用C#与LocalDB进行数据库操作，包括创建数据库、脱机操作、联机操作、数据库附加与分离，以及删除数据库。通过提供的代码示例，读者可以轻松掌握数据库管理的基本技能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

工作中涉及到一大批数据库的操作，特意写了以下demo程序备忘

<span style="white-space:pre">	</span>const int DbNumber = 5;
        private void btnCreate_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                var entity = new LocalDBEntities();
                var path = this.txtPath.Text;
                for (var i = 1; i <= DbNumber; i++)
                {
                    var command = string.Format("use master create database {0} on primary (name='{0}',filename='{1}\\{0}.mdf',size=5MB,maxsize=10MB,filegrowth=1MB) log on (name='{0}Log',filename='{1}\\{0}.ldf',size=2MB,maxsize=20MB,filegrowth=1MB)", "test" + i, path);
                    entity.Database.ExecuteSqlCommand(command);
                }

                MessageBox.Show("创建成功");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void btnOffline_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                var entity = new LocalDBEntities();
                var path = this.txtPath.Text;
                for (var i = 1; i <= DbNumber; i++)
                {
                    var command = string.Format("use master exec sp_dboption '{0}','offline','true'", "test" + i);
                    entity.Database.ExecuteSqlCommand(command);
                }

                MessageBox.Show("脱机成功");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void btnOnline_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                var entity = new LocalDBEntities();
                var path = this.txtPath.Text;
                for (var i = 1; i <= DbNumber; i++)
                {
                    var command = string.Format("use master exec sp_dboption '{0}','offline','false'", "test" + i);
                    entity.Database.ExecuteSqlCommand(command);
                }

                MessageBox.Show("联机成功");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void btnAttach_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                var entity = new LocalDBEntities();
                var path = this.txtPath.Text;
                for (var i = 1; i <= DbNumber; i++)
                {
                    var dbname = "test" + i;
                    var command = string.Format("use master exec sp_attach_db @dbname='{0}',@filename1='{1}',@filename2='{2}'"
                        , dbname
                        , path + "\\" + dbname + ".mdf"
                        , path + "\\" + dbname + ".ldf");
                    entity.Database.ExecuteSqlCommand(command);
                }

                MessageBox.Show("附加成功");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void btnDettach_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                var entity = new LocalDBEntities();
                var path = this.txtPath.Text;
                for (var i = 1; i <= DbNumber; i++)
                {
                    var command = string.Format("use master exec sp_detach_db '{0}'", "test" + i);
                    entity.Database.ExecuteSqlCommand(command);
                }

                MessageBox.Show("分离成功");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void btnDrop_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                var entity = new LocalDBEntities();
                var path = this.txtPath.Text;
                for (var i = 1; i <= DbNumber; i++)
                {
                    var command = string.Format("use master drop database {0}", "test" + i);
                    entity.Database.ExecuteSqlCommand(command);
                }

                MessageBox.Show("删除成功");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }