public void Contract_Contract()
{
using (var ctx = new TestContext())
{
var map = ctx.Db<Contract>();
var columns = map.Properties;
Assert.AreEqual(19, columns.Length);
map.Prop(x => x.Id)
.IsIdentity()
.IsFk(false)
.IsDiscriminator(false)
.IsRequired()
.HasColumnName("Id");
map.Prop(x => x.AvpContractNr)
.IsIdentity(false)
.IsFk(false)
.IsDiscriminator(false)
.IsRequired(false)
.HasColumnName("AvpContractNr")
.MaxLength(50);
}
}
public void Contract_ContractFixed()
{
using (var ctx = new TestContext())
{
var tableMapping = ctx.Db<ContractFixed>();
var columns = tableMapping.Properties;
Assert.AreEqual(21, columns.Length);
}
}
public void Contract_ContractBase()
{
using (var ctx = new TestContext())
{
var map = ctx.Db<ContractBase>();
var columns = map.Properties;
Assert.AreEqual(19, columns.Length);
Assert.AreEqual(1, map.Discriminators.Length);
}
}
public void Entity_ComplextType_WhereComplexTypeIsLastProperty()
{
using (var ctx = new TestContext())
{
var map = ctx.Db<House>();
map.Prop(x => x.Name)
.HasColumnName("Name");
map.Prop(x => x.Address.City)
.HasColumnName("Address_City");
}
}
public void Contract_ContractKomb1()
{
using (var ctx = new TestContext())
{
var tableMapping = ctx.Db<ContractKomb1>();
var columns = tableMapping.Properties;
Assert.AreEqual(24, columns.Length);
tableMapping.Prop(x => x.Base)
.HasColumnName("Base")
.HasPrecision(18)
.HasScale(4);
}
}
public void Entity_ComplexType()
{
using (var ctx = new TestContext())
{
var map = ctx.Db<TestUser>();
map.Prop(x => x.Id)
.HasColumnName("Id")
.IsPk()
.IsFk(false)
.IsNavigationProperty(false);
map.Prop(x => x.FirstName)
.HasColumnName("Name")
.IsPk(false)
.IsFk(false)
.IsNavigationProperty(false)
.MaxLength(NvarcharMax);
map.Prop(x => x.LastName)
.HasColumnName("LastName")
.IsPk(false)
.IsFk(false)
.IsNavigationProperty(false)
.MaxLength(NvarcharMax);
map.Prop(x => x.Contact.PhoneNumber)
.HasColumnName("Contact_PhoneNumber")
.IsPk(false)
.IsFk(false)
.IsNavigationProperty(false)
.MaxLength(NvarcharMax);
map.Prop(x => x.Contact.Address.Country)
.HasColumnName("Contact_Address_Country")
.IsPk(false)
.IsFk(false)
.IsNavigationProperty(false)
.MaxLength(NvarcharMax);
map.Prop(x => x.Contact.Address.County)
.HasColumnName("Contact_Address_County")
.IsPk(false)
.IsFk(false)
.IsNavigationProperty(false)
.MaxLength(NvarcharMax);
map.Prop(x => x.Contact.Address.City)
.HasColumnName("Contact_Address_City")
.IsPk(false)
.IsFk(false)
.IsNavigationProperty(false)
.MaxLength(NvarcharMax);
map.Prop(x => x.Contact.Address.PostalCode)
.HasColumnName("Contact_Address_PostalCode")
.IsPk(false)
.IsFk(false)
.IsNavigationProperty(false)
.MaxLength(NvarcharMax);
map.Prop(x => x.Contact.Address.StreetAddress)
.HasColumnName("Contact_Address_StreetAddress")
.IsPk(false)
.IsFk(false)
.IsNavigationProperty(false)
.MaxLength(NvarcharMax);
#if !NET40
var propertyPropertyMap = map.Prop(x => x.Contact.Address.Location);
propertyPropertyMap
.HasColumnName("Contact_Address_Location")
.IsPk(false)
.IsFk(false)
.IsNavigationProperty(false);
Console.WriteLine(propertyPropertyMap.DefaultValue);
Console.WriteLine(propertyPropertyMap.FixedLength);
Console.WriteLine(propertyPropertyMap.MaxLength);
Console.WriteLine(propertyPropertyMap.Precision);
Console.WriteLine(propertyPropertyMap.Scale);
Console.WriteLine(propertyPropertyMap.Type);
Console.WriteLine(propertyPropertyMap.Unicode);
var shapePropertyMap = map.Prop(x => x.Contact.Address.Shape);
shapePropertyMap
.HasColumnName("Contact_Address_Shape")
.IsPk(false)
.IsFk(false)
.IsNavigationProperty(false);
Console.WriteLine(shapePropertyMap.DefaultValue);
Console.WriteLine(shapePropertyMap.FixedLength);
Console.WriteLine(shapePropertyMap.MaxLength);
Console.WriteLine(shapePropertyMap.Precision);
Console.WriteLine(shapePropertyMap.Scale);
Console.WriteLine(shapePropertyMap.Type);
Console.WriteLine(shapePropertyMap.Unicode);
#endif
}
}
public void Entity_Simple()
{
using (var ctx = new TestContext())
{
var map = ctx.Db<Page>();
Console.WriteLine("{0}:{1}", map.Type, map.TableName);
map.Prop(x => x.PageId)
.HasColumnName("PageId")
.IsPk()
.IsFk(false)
.IsIdentity()
.IsNavigationProperty(false);
map.Prop(x => x.Title)
.HasColumnName("Title")
.IsPk(false)
.IsFk(false)
.IsIdentity(false)
.IsRequired()
.IsNavigationProperty(false)
.MaxLength(255);
map.Prop(x => x.Content)
.HasColumnName("Content")
.IsPk(false)
.IsFk(false)
.IsIdentity(false)
.IsRequired(false)
.IsNavigationProperty(false)
.MaxLength(NvarcharMax);
map.Prop(x => x.ParentId)
.HasColumnName("ParentId")
.IsPk(false)
.IsFk()
.IsIdentity(false)
.IsRequired(false)
.IsNavigationProperty(false)
.NavigationPropertyName("Parent");
Assert.AreEqual(map.Prop(x => x.PageId), map.Prop(x => x.ParentId).FkTargetColumn);
map.Prop(x => x.Parent)
.HasColumnName("ParentId")
.IsPk(false)
.IsFk(false)
.IsIdentity(false)
.IsNavigationProperty()
.ForeignKeyPropertyName("ParentId")
.ForeignKey(map.Prop(x => x.ParentId));
map.Prop(x => x.CreatedAt)
.HasColumnName("CreatedAt")
.IsPk(false)
.IsFk(false)
.IsIdentity(false)
.IsRequired(true)
.IsNavigationProperty(false);
map.Prop(x => x.ModifiedAt)
.HasColumnName("ModifiedAt")
.IsPk(false)
.IsFk(false)
.IsRequired(false)
.IsIdentity(false)
.IsNavigationProperty(false);
}
}
