public void CreateDataBase(string newDataBaseName, string dbPath) { sqlsvr.ConnectionContext.Connect(); var dbFileName = newDataBaseName;Database nDB = new Database(sqlsvr, newDataBaseName);
DataFile nMdfFile = new DataFile(); LogFile nLogFile = new LogFile(); nMdfFile.Name = newDataBase; var fileGroup = new FileGroup(); fileGroup.Parent = nDB; fileGroup.Name = "PRIMARY"; fileGroup.FileGroupType = FileGroupType.RowsFileGroup;
nMdfFile.Parent = fileGroup; nMdfFile.FileName = dbPath + dbFileName + ".mdf"; nMdfFile.GrowthType = FileGrowthType.None;//? nMdfFile.Growth = 0; nMdfFile.IsPrimaryFile = true;
fileGroup.Files.Add(nMdfFile); nDB.FileGroups.Add(fileGroup);
nLogFile.Parent = nDB; nLogFile.Name = newDataBaseName + "_Log"; nLogFile.FileName = dbPath + dbFileName + "_Log.ldf"; nDB.LogFiles.Add(nLogFile); nDB.Create(); sqlsvr.ConnectionContext.Disconnect(); }
转载于:https://www.cnblogs.com/ijunxiong/articles/9284120.html
相关资源：数据结构—成绩单生成器