/// <summary>
/// This is an internal API that supports the Entity Framework Core infrastructure and not subject to
/// the same compatibility standards as public APIs. It may be changed or removed without notice in
/// any release. You should only use it directly in your code with extreme caution and knowing that
/// doing so can result in application failures when updating to a new Entity Framework Core release.
/// </summary>
protected virtual SequenceBuilder VisitSequence([NotNull] ModelBuilder modelBuilder, [NotNull] DatabaseSequence sequence)
{
Check.NotNull(modelBuilder, nameof(modelBuilder));
Check.NotNull(sequence, nameof(sequence));
if (string.IsNullOrEmpty(sequence.Name))
{
_reporter.WriteWarning(DesignStrings.SequencesRequireName);
return(null);
}
Type sequenceType = null;
if (sequence.StoreType != null)
{
sequenceType = _scaffoldingTypeMapper.FindMapping(
sequence.StoreType,
keyOrIndex: false,
rowVersion: false)
?.ClrType;
}
if (sequenceType != null &&
!Sequence.SupportedTypes.Contains(sequenceType))
{
_reporter.WriteWarning(DesignStrings.BadSequenceType(sequence.Name, sequence.StoreType));
return(null);
}
var builder = sequenceType != null
? modelBuilder.HasSequence(sequenceType, sequence.Name, sequence.Schema)
: modelBuilder.HasSequence(sequence.Name, sequence.Schema);
if (sequence.IncrementBy.HasValue)
{
builder.IncrementsBy(sequence.IncrementBy.Value);
}
if (sequence.MaxValue.HasValue)
{
builder.HasMax(sequence.MaxValue.Value);
}
if (sequence.MinValue.HasValue)
{
builder.HasMin(sequence.MinValue.Value);
}
if (sequence.StartValue.HasValue)
{
builder.StartsAt(sequence.StartValue.Value);
}
if (sequence.IsCyclic.HasValue)
{
builder.IsCyclic(sequence.IsCyclic.Value);
}
return(builder);
}
public void Sequences()
{
using (var scratch = SqlServerTestStore.Create("SqlServerE2E"))
{
scratch.ExecuteNonQuery(@"
CREATE SEQUENCE CountByTwo
START WITH 1
INCREMENT BY 2;
CREATE SEQUENCE CyclicalCountByThree
START WITH 6
INCREMENT BY 3
MAXVALUE 27
MINVALUE 0
CYCLE;
CREATE SEQUENCE TinyIntSequence
AS tinyint
START WITH 1;
CREATE SEQUENCE SmallIntSequence
AS smallint
START WITH 1;
CREATE SEQUENCE IntSequence
AS int
START WITH 1;
CREATE SEQUENCE DecimalSequence
AS decimal;
CREATE SEQUENCE NumericSequence
AS numeric;");
var expectedFileSet = new FileSet(
new FileSystemFileService(),
Path.Combine("ReverseEngineering", "Expected"),
contents => contents.Replace("{{connectionString}}", scratch.ConnectionString))
{
Files = new List <string> {
"SequenceContext.cs"
}
};
var filePaths = Generator.Generate(
scratch.ConnectionString,
Enumerable.Empty <string>(),
Enumerable.Empty <string>(),
TestProjectDir + Path.DirectorySeparatorChar,
outputPath: null, // not used for this test
rootNamespace: TestNamespace,
contextName: "SequenceContext",
useDataAnnotations: false,
overwriteFiles: false,
useDatabaseNames: false);
var actualFileSet = new FileSet(InMemoryFiles, Path.GetFullPath(TestProjectDir))
{
Files = new[] { filePaths.ContextFile }.Concat(filePaths.EntityTypeFiles).Select(Path.GetFileName).ToList()
};
Assert.Contains("warn: " + DesignStrings.BadSequenceType("DecimalSequence", "decimal"), _reporter.Messages);
Assert.Contains("warn: " + DesignStrings.BadSequenceType("NumericSequence", "numeric"), _reporter.Messages);
Assert.Equal(2, _reporter.Messages.Count(m => m.StartsWith("warn: ")));
AssertEqualFileContents(expectedFileSet, actualFileSet);
AssertCompile(actualFileSet);
}
}
