public void CanGetModelValidationErrors()
{
// Arrange
var model = new TestModelBuilder()
.AddStoredProcedureFromFile("../../../../TestProjectWithErrors/Procedures/csp_Test.sql")
.Build();
// Act
var modelValidationErrors = model.GetModelValidationErrors(Enumerable.Empty <string>());
// Assert
modelValidationErrors.ShouldNotBeEmpty();
var error = modelValidationErrors.First();
error.Severity.ShouldBe(Microsoft.SqlServer.Dac.Model.ModelErrorSeverity.Error);
error.ToString().ShouldBe("../../../../TestProjectWithErrors/Procedures/csp_Test.sql(2,18):ModelValidationError Error SQL71501: SqlSubroutineParameter: [dbo].[csp_Test].[@p_Parameter] has an unresolved reference to SqlBuiltInType [dbo].[MyCustomType].");
}
public void CanGetModelValidationErrors()
{
// Arrange
var model = new TestModelBuilder()
.AddStoredProcedureFromFile("../../../../TestProjectWithErrors/Procedures/csp_Test.sql")
.Build();
// Act
var modelValidationErrors = model.GetModelValidationErrors(Enumerable.Empty <string>());
// Assert
modelValidationErrors.ShouldNotBeEmpty();
var error = modelValidationErrors.First();
error.Severity.ShouldBe(Microsoft.SqlServer.Dac.Model.ModelErrorSeverity.Error);
error.ErrorCode.ShouldBe(71501);
error.SourceName.ShouldBe("../../../../TestProjectWithErrors/Procedures/csp_Test.sql", StringCompareShould.IgnoreCase);
}
