/// <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); } }