Unable to create a default DataFile object on a ManagedInstance database

Run the following code snippet (tweak the connection string ("...") to point to a ManagedInstance server):

var dbname = "bugDB";
var srvconn = new ServerConnection(new SqlConnection("..."));
var srv3 = new SMO.Server(srvconn);
var db = new SMO.Database(srv3, dbname);
db.Create();
                
DataFile df = new DataFile(db.FileGroups[0], "MatteoDF"); 
df.Create();

It won't work.

If you set some properties on the DataFile object before the creation, it'll work.

首先，使用指向 Managed Instance 的连接字符串运行 C# 复现代码，重点关注 db.Create() 之后的 DataFile 创建。比较失败的默认 DataFile 路径与在 df.Create() 之前设置属性时的情况，并利用这一行为确定缺失的创建要求。当代码片段无需手动设置这些属性即可创建 DataFile 时，即表示完成。