/// <summary>
/// Get SQL database model from a .dacpac file
/// </summary>
/// <param name="dacpacFileName"></param>
/// <returns></returns>
public static TSqlModel LoadModel(string dacpacFileName)
{
ModelLoadOptions options = new ModelLoadOptions()
{
LoadAsScriptBackedModel = false,
ModelStorageType = DacSchemaModelStorageType.File
};
return(TSqlModel.LoadFromDacpac(dacpacFileName, options));
}
/// <summary>
/// Initializes host with database package on the specified path.
/// </summary>
/// <param name="databasePackagePath">Absolute path to the database package.</param>
public void Initialize(string databasePackagePath)
{
var options = new ModelLoadOptions();
options.LoadAsScriptBackedModel = true;
options.ModelStorageType = DacSchemaModelStorageType.File;
TSqlModel model = TSqlModel.LoadFromDacpac(databasePackagePath, options);
using (model)
{
_schema = DatabaseSchema.FromModel(model);
}
}
/// <summary>
/// Initializes host with database package on the specified path.
/// </summary>
/// <param name="databasePackagePath">Absolute path to the database package.</param>
public void Initialize(string databasePackagePath)
{
var options = new ModelLoadOptions();
options.LoadAsScriptBackedModel = true;
options.ModelStorageType = DacSchemaModelStorageType.File;
TSqlModel model = TSqlModel.LoadFromDacpac(databasePackagePath, options);
using (model)
{
_schema = DatabaseSchema.FromModel(model);
}
}
