//
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 ZmianaEntityType
{
public static RuntimeEntityType Create(RuntimeModel model, RuntimeEntityType baseEntityType = null)
{
var runtimeEntityType = model.AddEntityType(
"DuSoft.PcmDb.Entities.Zmiana",
typeof(Zmiana),
baseEntityType);
var zmId = runtimeEntityType.AddProperty(
"ZmId",
typeof(decimal),
propertyInfo: typeof(Zmiana).GetProperty("ZmId", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(Zmiana).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly),
valueGenerated: ValueGenerated.OnAdd,
afterSaveBehavior: PropertySaveBehavior.Throw,
sentinel: 0m);
zmId.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));
zmId.AddAnnotation("Relational:ColumnType", "numeric(9, 0)");
zmId.AddAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
var akcja = runtimeEntityType.AddProperty(
"Akcja",
typeof(short),
propertyInfo: typeof(Zmiana).GetProperty("Akcja", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(Zmiana).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly),
sentinel: (short)0);
akcja.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));
akcja.AddAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.None);
var czas = runtimeEntityType.AddProperty(
"Czas",
typeof(DateTime),
propertyInfo: typeof(Zmiana).GetProperty("Czas", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(Zmiana).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly),
sentinel: new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified));
czas.TypeMapping = SqlServerDateTimeTypeMapping.Default.Clone(
comparer: new ValueComparer(
(DateTime v1, DateTime v2) => v1.Equals(v2),
(DateTime v) => v.GetHashCode(),
(DateTime v) => v),
keyComparer: new ValueComparer(
(DateTime v1, DateTime v2) => v1.Equals(v2),
(DateTime v) => v.GetHashCode(),
(DateTime v) => v),
providerValueComparer: new ValueComparer(
(DateTime v1, DateTime v2) => v1.Equals(v2),
(DateTime v) => v.GetHashCode(),
(DateTime v) => v),
mappingInfo: new RelationalTypeMappingInfo(
storeTypeName: "datetime",
dbType: System.Data.DbType.DateTime));
czas.AddAnnotation("Relational:ColumnType", "datetime");
czas.AddAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.None);
var sesjaId = runtimeEntityType.AddProperty(
"SesjaId",
typeof(decimal),
propertyInfo: typeof(Zmiana).GetProperty("SesjaId", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(Zmiana).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly),
sentinel: 0m);
sesjaId.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));
sesjaId.AddAnnotation("Relational:ColumnType", "numeric(9, 0)");
sesjaId.AddAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.None);
var sklepId = runtimeEntityType.AddProperty(
"SklepId",
typeof(decimal?),
propertyInfo: typeof(Zmiana).GetProperty("SklepId", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(Zmiana).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly),
nullable: true);
sklepId.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: "numeric(9,0)",
precision: 9,
scale: 0));
sklepId.AddAnnotation("Relational:ColumnType", "numeric(9, 0)");
sklepId.AddAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.None);
var tabId = runtimeEntityType.AddProperty(
"TabId",
typeof(decimal?),
propertyInfo: typeof(Zmiana).GetProperty("TabId", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(Zmiana).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly),
nullable: true);
tabId.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: "numeric(9,0)",
precision: 9,
scale: 0));
tabId.AddAnnotation("Relational:ColumnType", "numeric(9, 0)");
tabId.AddAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.None);
var tabela = runtimeEntityType.AddProperty(
"Tabela",
typeof(short),
propertyInfo: typeof(Zmiana).GetProperty("Tabela", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(Zmiana).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly),
sentinel: (short)0);
tabela.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));
tabela.AddAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.None);
var tekst = runtimeEntityType.AddProperty(
"Tekst",
typeof(string),
propertyInfo: typeof(Zmiana).GetProperty("Tekst", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(Zmiana).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly),
maxLength: 40,
unicode: false);
tekst.TypeMapping = SqlServerStringTypeMapping.Default.Clone(
comparer: new ValueComparer(
(string v1, string v2) => v1 == v2,
(string v) => v.GetHashCode(),
(string v) => v),
keyComparer: new ValueComparer(
(string v1, string v2) => v1 == v2,
(string v) => v.GetHashCode(),
(string v) => v),
providerValueComparer: new ValueComparer(
(string v1, string v2) => v1 == v2,
(string v) => v.GetHashCode(),
(string v) => v),
mappingInfo: new RelationalTypeMappingInfo(
storeTypeName: "varchar(40)",
size: 40));
tekst.AddAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.None);
var key = runtimeEntityType.AddKey(
new[] { zmId });
runtimeEntityType.SetPrimaryKey(key);
key.AddAnnotation("Relational:Name", "PK_ZMIANA");
var idx_ZmSkTabIdCzas = runtimeEntityType.AddIndex(
new[] { sklepId, tabId, czas },
name: "idx_ZmSkTabIdCzas");
var idx_ZmTabIdCzas = runtimeEntityType.AddIndex(
new[] { tabId, czas },
name: "idx_ZmTabIdCzas");
var idx_ZmianaSesjaId = runtimeEntityType.AddIndex(
new[] { sesjaId },
name: "idx_ZmianaSesjaId");
return runtimeEntityType;
}
public static RuntimeForeignKey CreateForeignKey1(RuntimeEntityType declaringEntityType, RuntimeEntityType principalEntityType)
{
var runtimeForeignKey = declaringEntityType.AddForeignKey(new[] { declaringEntityType.FindProperty("SesjaId") },
principalEntityType.FindKey(new[] { principalEntityType.FindProperty("SesjaId") }),
principalEntityType,
required: true);
var sesja = declaringEntityType.AddNavigation("Sesja",
runtimeForeignKey,
onDependent: true,
typeof(Sesja),
propertyInfo: typeof(Zmiana).GetProperty("Sesja", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(Zmiana).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly));
var zmiana = principalEntityType.AddNavigation("Zmiana",
runtimeForeignKey,
onDependent: false,
typeof(ICollection),
propertyInfo: typeof(Sesja).GetProperty("Zmiana", BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly),
fieldInfo: typeof(Sesja).GetField("k__BackingField", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly));
runtimeForeignKey.AddAnnotation("Relational:Name", "FK_ZMIANA_REF_SESJA_SESJA");
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", "Zmiana");
runtimeEntityType.AddAnnotation("Relational:ViewName", null);
runtimeEntityType.AddAnnotation("Relational:ViewSchema", null);
Customize(runtimeEntityType);
}
static partial void Customize(RuntimeEntityType runtimeEntityType);
}
}