//
using System;
using System.Collections.Generic;
using System.Reflection;
using DuSoft.PcmDb.Entities;
using Microsoft.EntityFrameworkCore.ChangeTracking;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal;
using Microsoft.EntityFrameworkCore.Storage;
#pragma warning disable 219, 612, 618
#nullable disable
namespace DuSoft.PcmDb.CompiledEntities
{
internal partial class TowarSkladnikaEntityType
{
public static RuntimeEntityType Create(RuntimeModel model, RuntimeEntityType baseEntityType = null)
{
var runtimeEntityType = model.AddEntityType(
"DuSoft.PcmDb.Entities.TowarSkladnika",
typeof(TowarSkladnika),
baseEntityType);
var skWzId = runtimeEntityType.AddProperty(
"SkWzId",
typeof(decimal),
propertyInfo: typeof(TowarSkladnika).GetProperty("SkWzId", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(TowarSkladnika).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly),
afterSaveBehavior: PropertySaveBehavior.Throw,
sentinel: 0m);
skWzId.TypeMapping = SqlServerDecimalTypeMapping.Default.Clone(
comparer: new ValueComparer(
(decimal v1, decimal v2) => v1 == v2,
(decimal v) => v.GetHashCode(),
(decimal v) => v),
keyComparer: new ValueComparer(
(decimal v1, decimal v2) => v1 == v2,
(decimal v) => v.GetHashCode(),
(decimal v) => v),
providerValueComparer: new ValueComparer(
(decimal v1, decimal v2) => v1 == v2,
(decimal v) => v.GetHashCode(),
(decimal v) => v),
mappingInfo: new RelationalTypeMappingInfo(
storeTypeName: "numeric(9,0)",
precision: 9,
scale: 0));
skWzId.AddAnnotation("Relational:ColumnType", "numeric(9, 0)");
skWzId.AddAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.None);
var towId = runtimeEntityType.AddProperty(
"TowId",
typeof(decimal),
propertyInfo: typeof(TowarSkladnika).GetProperty("TowId", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(TowarSkladnika).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly),
afterSaveBehavior: PropertySaveBehavior.Throw,
sentinel: 0m);
towId.TypeMapping = SqlServerDecimalTypeMapping.Default.Clone(
comparer: new ValueComparer(
(decimal v1, decimal v2) => v1 == v2,
(decimal v) => v.GetHashCode(),
(decimal v) => v),
keyComparer: new ValueComparer(
(decimal v1, decimal v2) => v1 == v2,
(decimal v) => v.GetHashCode(),
(decimal v) => v),
providerValueComparer: new ValueComparer(
(decimal v1, decimal v2) => v1 == v2,
(decimal v) => v.GetHashCode(),
(decimal v) => v),
mappingInfo: new RelationalTypeMappingInfo(
storeTypeName: "numeric(9,0)",
precision: 9,
scale: 0));
towId.AddAnnotation("Relational:ColumnType", "numeric(9, 0)");
towId.AddAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.None);
var cena = runtimeEntityType.AddProperty(
"Cena",
typeof(decimal?),
propertyInfo: typeof(TowarSkladnika).GetProperty("Cena", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(TowarSkladnika).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly),
nullable: true);
cena.TypeMapping = SqlServerDecimalTypeMapping.Default.Clone(
comparer: new ValueComparer(
(Nullable v1, Nullable v2) => v1.HasValue && v2.HasValue && (decimal)v1 == (decimal)v2 || !v1.HasValue && !v2.HasValue,
(Nullable v) => v.HasValue ? ((decimal)v).GetHashCode() : 0,
(Nullable v) => v.HasValue ? (Nullable)(decimal)v : default(Nullable)),
keyComparer: new ValueComparer(
(Nullable v1, Nullable v2) => v1.HasValue && v2.HasValue && (decimal)v1 == (decimal)v2 || !v1.HasValue && !v2.HasValue,
(Nullable v) => v.HasValue ? ((decimal)v).GetHashCode() : 0,
(Nullable v) => v.HasValue ? (Nullable)(decimal)v : default(Nullable)),
providerValueComparer: new ValueComparer(
(Nullable v1, Nullable v2) => v1.HasValue && v2.HasValue && (decimal)v1 == (decimal)v2 || !v1.HasValue && !v2.HasValue,
(Nullable v) => v.HasValue ? ((decimal)v).GetHashCode() : 0,
(Nullable v) => v.HasValue ? (Nullable)(decimal)v : default(Nullable)),
mappingInfo: new RelationalTypeMappingInfo(
storeTypeName: "decimal(15,4)",
precision: 15,
scale: 4));
cena.AddAnnotation("Relational:ColumnType", "decimal(15, 4)");
cena.AddAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.None);
var cenaZKartyTow = runtimeEntityType.AddProperty(
"CenaZKartyTow",
typeof(short?),
propertyInfo: typeof(TowarSkladnika).GetProperty("CenaZKartyTow", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(TowarSkladnika).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly),
nullable: true);
cenaZKartyTow.TypeMapping = SqlServerShortTypeMapping.Default.Clone(
comparer: new ValueComparer(
(Nullable v1, Nullable v2) => v1.HasValue && v2.HasValue && (short)v1 == (short)v2 || !v1.HasValue && !v2.HasValue,
(Nullable v) => v.HasValue ? (int)(short)v : 0,
(Nullable v) => v.HasValue ? (Nullable)(short)v : default(Nullable)),
keyComparer: new ValueComparer(
(Nullable v1, Nullable v2) => v1.HasValue && v2.HasValue && (short)v1 == (short)v2 || !v1.HasValue && !v2.HasValue,
(Nullable v) => v.HasValue ? (int)(short)v : 0,
(Nullable v) => v.HasValue ? (Nullable)(short)v : default(Nullable)),
providerValueComparer: new ValueComparer(
(Nullable v1, Nullable v2) => v1.HasValue && v2.HasValue && (short)v1 == (short)v2 || !v1.HasValue && !v2.HasValue,
(Nullable v) => v.HasValue ? (int)(short)v : 0,
(Nullable v) => v.HasValue ? (Nullable)(short)v : default(Nullable)));
cenaZKartyTow.AddAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.None);
var domyslny = runtimeEntityType.AddProperty(
"Domyslny",
typeof(short?),
propertyInfo: typeof(TowarSkladnika).GetProperty("Domyslny", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(TowarSkladnika).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly),
nullable: true);
domyslny.TypeMapping = SqlServerShortTypeMapping.Default.Clone(
comparer: new ValueComparer(
(Nullable v1, Nullable v2) => v1.HasValue && v2.HasValue && (short)v1 == (short)v2 || !v1.HasValue && !v2.HasValue,
(Nullable v) => v.HasValue ? (int)(short)v : 0,
(Nullable v) => v.HasValue ? (Nullable)(short)v : default(Nullable)),
keyComparer: new ValueComparer(
(Nullable v1, Nullable v2) => v1.HasValue && v2.HasValue && (short)v1 == (short)v2 || !v1.HasValue && !v2.HasValue,
(Nullable v) => v.HasValue ? (int)(short)v : 0,
(Nullable v) => v.HasValue ? (Nullable)(short)v : default(Nullable)),
providerValueComparer: new ValueComparer(
(Nullable v1, Nullable v2) => v1.HasValue && v2.HasValue && (short)v1 == (short)v2 || !v1.HasValue && !v2.HasValue,
(Nullable v) => v.HasValue ? (int)(short)v : 0,
(Nullable v) => v.HasValue ? (Nullable)(short)v : default(Nullable)));
domyslny.AddAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.None);
var ilosc = runtimeEntityType.AddProperty(
"Ilosc",
typeof(decimal?),
propertyInfo: typeof(TowarSkladnika).GetProperty("Ilosc", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(TowarSkladnika).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly),
nullable: true);
ilosc.TypeMapping = SqlServerDecimalTypeMapping.Default.Clone(
comparer: new ValueComparer(
(Nullable v1, Nullable v2) => v1.HasValue && v2.HasValue && (decimal)v1 == (decimal)v2 || !v1.HasValue && !v2.HasValue,
(Nullable v) => v.HasValue ? ((decimal)v).GetHashCode() : 0,
(Nullable v) => v.HasValue ? (Nullable)(decimal)v : default(Nullable)),
keyComparer: new ValueComparer(
(Nullable v1, Nullable v2) => v1.HasValue && v2.HasValue && (decimal)v1 == (decimal)v2 || !v1.HasValue && !v2.HasValue,
(Nullable v) => v.HasValue ? ((decimal)v).GetHashCode() : 0,
(Nullable v) => v.HasValue ? (Nullable)(decimal)v : default(Nullable)),
providerValueComparer: new ValueComparer(
(Nullable v1, Nullable v2) => v1.HasValue && v2.HasValue && (decimal)v1 == (decimal)v2 || !v1.HasValue && !v2.HasValue,
(Nullable v) => v.HasValue ? ((decimal)v).GetHashCode() : 0,
(Nullable v) => v.HasValue ? (Nullable)(decimal)v : default(Nullable)),
mappingInfo: new RelationalTypeMappingInfo(
storeTypeName: "decimal(15,4)",
precision: 15,
scale: 4));
ilosc.AddAnnotation("Relational:ColumnType", "decimal(15, 4)");
ilosc.AddAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.None);
var kolejnosc = runtimeEntityType.AddProperty(
"Kolejnosc",
typeof(short),
propertyInfo: typeof(TowarSkladnika).GetProperty("Kolejnosc", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(TowarSkladnika).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly),
sentinel: (short)0);
kolejnosc.TypeMapping = SqlServerShortTypeMapping.Default.Clone(
comparer: new ValueComparer(
(short v1, short v2) => v1 == v2,
(short v) => (int)v,
(short v) => v),
keyComparer: new ValueComparer(
(short v1, short v2) => v1 == v2,
(short v) => (int)v,
(short v) => v),
providerValueComparer: new ValueComparer(
(short v1, short v2) => v1 == v2,
(short v) => (int)v,
(short v) => v));
kolejnosc.AddAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.None);
var key = runtimeEntityType.AddKey(
new[] { skWzId, towId });
runtimeEntityType.SetPrimaryKey(key);
key.AddAnnotation("Relational:Name", "PK_TOWARSKLADNIKA");
var index = runtimeEntityType.AddIndex(
new[] { towId });
var idx_TowarSkladniaka = runtimeEntityType.AddIndex(
new[] { skWzId },
name: "idx_TowarSkladniaka");
return runtimeEntityType;
}
public static RuntimeForeignKey CreateForeignKey1(RuntimeEntityType declaringEntityType, RuntimeEntityType principalEntityType)
{
var runtimeForeignKey = declaringEntityType.AddForeignKey(new[] { declaringEntityType.FindProperty("SkWzId") },
principalEntityType.FindKey(new[] { principalEntityType.FindProperty("SkWzId") }),
principalEntityType,
required: true);
var skWz = declaringEntityType.AddNavigation("SkWz",
runtimeForeignKey,
onDependent: true,
typeof(SkladnikWzorca),
propertyInfo: typeof(TowarSkladnika).GetProperty("SkWz", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(TowarSkladnika).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly));
var towarSkladnika = principalEntityType.AddNavigation("TowarSkladnika",
runtimeForeignKey,
onDependent: false,
typeof(ICollection),
propertyInfo: typeof(SkladnikWzorca).GetProperty("TowarSkladnika", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(SkladnikWzorca).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly));
runtimeForeignKey.AddAnnotation("Relational:Name", "FK_TOWARSKLADNIKA_REFERENCE_SKLADNIKWZORCA");
return runtimeForeignKey;
}
public static RuntimeForeignKey CreateForeignKey2(RuntimeEntityType declaringEntityType, RuntimeEntityType principalEntityType)
{
var runtimeForeignKey = declaringEntityType.AddForeignKey(new[] { declaringEntityType.FindProperty("TowId") },
principalEntityType.FindKey(new[] { principalEntityType.FindProperty("TowId") }),
principalEntityType,
required: true);
var tow = declaringEntityType.AddNavigation("Tow",
runtimeForeignKey,
onDependent: true,
typeof(Towar),
propertyInfo: typeof(TowarSkladnika).GetProperty("Tow", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(TowarSkladnika).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly));
var towarSkladnika = principalEntityType.AddNavigation("TowarSkladnika",
runtimeForeignKey,
onDependent: false,
typeof(ICollection),
propertyInfo: typeof(Towar).GetProperty("TowarSkladnika", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(Towar).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly));
runtimeForeignKey.AddAnnotation("Relational:Name", "FK_TOWARSKLADNIKA_REFERENCE_TOWAR");
return runtimeForeignKey;
}
public static void CreateAnnotations(RuntimeEntityType runtimeEntityType)
{
runtimeEntityType.AddAnnotation("Relational:FunctionName", null);
runtimeEntityType.AddAnnotation("Relational:Schema", null);
runtimeEntityType.AddAnnotation("Relational:SqlQuery", null);
runtimeEntityType.AddAnnotation("Relational:TableName", "TowarSkladnika");
runtimeEntityType.AddAnnotation("Relational:ViewName", null);
runtimeEntityType.AddAnnotation("Relational:ViewSchema", null);
Customize(runtimeEntityType);
}
static partial void Customize(RuntimeEntityType runtimeEntityType);
}
}