public void Block_size_is_obtained_from_named_sequence()
{
var property = CreateConventionModelBuilder()
.Entity<Robot>()
.Property(e => e.Id)
.UseSqlServerSequenceHiLo("DaneelOlivaw")
.Metadata;
var cache = new SqlServerValueGeneratorCache();
Assert.Equal(10, cache.GetOrAddSequenceState(property).Sequence.IncrementBy);
}
public void Block_size_is_obtained_from_named_sequence()
{
var property = CreateConventionModelBuilder()
.Entity<Robot>()
.Property(e => e.Id)
.ForSqlServer(b => b.UseSequence("DaneelOlivaw"))
.Metadata;
var cache = new SqlServerValueGeneratorCache();
Assert.Equal(10, cache.GetBlockSize(property));
}
public void Block_size_is_obtained_from_default_sequence()
{
var property = CreateConventionModelBuilder()
.Entity<Robot>()
.Property(e => e.Id)
.UseSqlServerSequenceHiLo()
.Metadata;
var cache = new SqlServerValueGeneratorCache();
Assert.Equal(10, cache.GetBlockSize(property));
}
public void Returns_the_default_pool_size()
{
var property = CreateProperty();
var cache = new SqlServerValueGeneratorCache();
Assert.Equal(5, cache.GetPoolSize(property));
}
public void Schema_qualified_sequence_name_is_obtained_from_specified_model_default_sequence()
{
var property = CreateConventionModelBuilder()
.ForSqlServer(b =>
{
b.UseSequence("DaneelOlivaw", "R");
b.Sequence("DaneelOlivaw", "R").IncrementBy(11);
})
.Entity<Robot>()
.Property(e => e.Id)
.GenerateValueOnAdd()
.ForSqlServer(b => b.UseDefaultValueGeneration())
.Metadata;
var cache = new SqlServerValueGeneratorCache();
Assert.Equal("R.DaneelOlivaw", cache.GetSequenceName(property));
}
public void Schema_qualified_sequence_name_is_obtained_from_named_sequence()
{
var property = CreateConventionModelBuilder()
.Entity<Robot>()
.Property(e => e.Id)
.ForSqlServer(b => b.UseSequence("DaneelOlivaw", "R"))
.Metadata;
var cache = new SqlServerValueGeneratorCache();
Assert.Equal("R.DaneelOlivaw", cache.GetSequenceName(property));
}
public void Sequence_name_is_obtained_from_specified_default_sequence()
{
var property = CreateConventionModelBuilder()
.ForSqlServer(b => b.Sequence().IncrementBy(11))
.Entity<Robot>()
.Property(e => e.Id)
.ForSqlServer(b => b.UseSequence())
.Metadata;
var cache = new SqlServerValueGeneratorCache();
Assert.Equal("DefaultSequence", cache.GetSequenceName(property));
}
public void Non_positive_block_sizes_are_not_allowed()
{
var property = CreateConventionModelBuilder()
.ForSqlServer(b => b.Sequence("DaneelOlivaw").IncrementBy(-1))
.Entity<Robot>()
.Property(e => e.Id)
.ForSqlServer(b => b.UseSequence("DaneelOlivaw"))
.Metadata;
var cache = new SqlServerValueGeneratorCache();
Assert.Equal(
Strings.SequenceBadBlockSize(-1, "DaneelOlivaw"),
Assert.Throws<NotSupportedException>(() => cache.GetBlockSize(property)).Message);
}
public void Block_size_is_obtained_from_model_specified_model_default_sequence()
{
var property = CreateConventionModelBuilder()
.ForSqlServer(b =>
{
b.UseSequence();
b.Sequence().IncrementBy(11);
})
.Entity<Robot>()
.Property(e => e.Id)
.GenerateValueOnAdd()
.ForSqlServer(b => b.UseDefaultValueGeneration())
.Metadata;
var cache = new SqlServerValueGeneratorCache();
Assert.Equal(11, cache.GetBlockSize(property));
}
public void Non_positive_pool_sizes_are_not_allowed()
{
var property = CreateConventionModelBuilder()
.Entity<Robot>()
.Property(e => e.Id)
.UseSqlServerSequenceHiLo()
.Metadata;
property[SqlServerAnnotationNames.Prefix + SqlServerAnnotationNames.HiLoSequencePoolSize] = 0;
var cache = new SqlServerValueGeneratorCache();
Assert.StartsWith(
Internal.Strings.HiLoBadPoolSize,
Assert.Throws<ArgumentOutOfRangeException>(() => cache.GetOrAddSequenceState(property)).Message);
}
public void Pool_size_is_obtained_from__model()
{
var property = CreateProperty();
property.DeclaringEntityType.Model.SqlServer().HiLoSequencePoolSize = 10;
var cache = new SqlServerValueGeneratorCache();
Assert.Equal(10, cache.GetPoolSize(property));
}
public void Schema_qualified_sequence_name_is_obtained_from_specified_model_default_sequence()
{
var property = CreateConventionModelBuilder()
.UseSqlServerSequenceHiLo("DaneelOlivaw", "R")
.SqlServerSequence("DaneelOlivaw", "R", b => b.IncrementsBy(11))
.Entity<Robot>()
.Property(e => e.Id)
.Metadata;
var cache = new SqlServerValueGeneratorCache();
Assert.Equal("DaneelOlivaw", cache.GetOrAddSequenceState(property).Sequence.Name);
Assert.Equal("R", cache.GetOrAddSequenceState(property).Sequence.Schema);
}
public void Sequence_name_is_obtained_from_model_default_sequence()
{
var property = CreateConventionModelBuilder()
.UseSqlServerSequenceHiLo()
.Entity<Robot>()
.Property(e => e.Id)
.Metadata;
var cache = new SqlServerValueGeneratorCache();
Assert.Equal("DefaultSequence", cache.GetOrAddSequenceState(property).Sequence.Name);
}
public void Non_positive_block_sizes_are_not_allowed()
{
var property = CreateConventionModelBuilder()
.SqlServerSequence("DaneelOlivaw", b => b.IncrementsBy(-1))
.Entity<Robot>()
.Property(e => e.Id)
.UseSqlServerSequenceHiLo("DaneelOlivaw")
.Metadata;
var cache = new SqlServerValueGeneratorCache();
Assert.StartsWith(
Internal.Strings.HiLoBadBlockSize,
Assert.Throws<ArgumentOutOfRangeException>(() => cache.GetOrAddSequenceState(property).Sequence.IncrementBy).Message);
}
public void Sequence_name_is_obtained_from_specified_sequence()
{
var property = CreateConventionModelBuilder()
.SqlServerSequence("DaneelOlivaw", b => b.IncrementBy(11))
.Entity<Robot>()
.Property(e => e.Id)
.UseSqlServerSequenceHiLo("DaneelOlivaw")
.Metadata;
var cache = new SqlServerValueGeneratorCache();
Assert.Equal("DaneelOlivaw", cache.GetSequenceName(property));
}
