entity 数据连接指定密码_metadataworkspace.registeritemcollection-优快云博客

本文链接：https://blog.youkuaiyun.com/tastelife/article/details/7895233

本文详细介绍了如何配置数据库模型并建立SQL连接，包括CSDL、SSDL、MSL文件的使用，以及如何注册和使用元数据工作区，同时展示了SQL连接字符串的构建过程。

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

                string csdl = @"res://*/MainDBModel.csdl";
                string ssdl = @"res://*/MainDBModel.ssdl";
                string msl = @"res://*/MainDBModel.msl";

                var edmItemCollection = new EdmItemCollection(csdl);

                var storeItemCollection = new StoreItemCollection(ssdl);

                var storeMappingItemCollection = new StorageMappingItemCollection(
                      edmItemCollection,
                      storeItemCollection,
                      msl
                   );

                _metadataWorkspace.RegisterItemCollection(edmItemCollection);
                _metadataWorkspace.RegisterItemCollection(storeItemCollection);
                _metadataWorkspace.RegisterItemCollection(storeMappingItemCollection);

                SqlConnectionStringBuilder scb = new SqlConnectionStringBuilder();
                scb.DataSource = "192.168.0.1"+ @"\" + "dbName;"
                scb.UserID = "wx";
                scb.Password = "123456";
                scb.InitialCatalog = "wx";
                _sqlConnection.ConnectionString = scb.ConnectionString;