ATNEL tech-forum

Re: C# Entity Framework nazwa klucza obcego

2016-10-27T11:40:54+01:00

Zmagań ciąg dalszy. Wymyśliłem sobie, że w DictionarySlave para DictionaryMaster i DictSlaveKey będą stanowiły indeks unikalny. Czyli że w ramach klucza głównego klucze podrzędne muszą być unikalne natomiast klucze podrzędne mogą się powtarzać w różnych kluczach nadrzędnych i nie chodzi tu relację master to slave a o duble kluczy slave z różnymi DS_DMID.
Z atrybutami wygląda to tak:
[syntax=csharp][Table("dictionaryslave")]
public class DictionarySlave
{
[Key]
[Column("ID")]
public int DictionarySlaveID { get; set; }

[Column("DS_KEY", TypeName = "char")]
[Index("IX_Key"), StringLength(10)]
[Index("IX_DmWithKey", 2, IsUnique = true)]
public string DictSlaveKey { get; set; }

[Column("DS_DESCRIPTION", TypeName = "nvarchar")]
[Index("IX_Description"), StringLength(50)]
public string DictSlaveDescription { get; set; }

[Column("DS_VALUE1")]
[DecimalPrecision(11, 2)]
public decimal? DictSlaveValue1 { get; set; }

[Column("DS_VALUE2")]
[DecimalPrecision(11, 2)]
public decimal? DictSlaveValue2 { get; set; }

[ForeignKey("DictionaryMaster")]
[Column("DS_DMID")]
[Index("IX_DmWithKey", 1, IsUnique = true)]
public int DictionaryMasterID { get; set; }

public DictionaryMaster DictionaryMaster { get; set; }
}[/syntax]

i daje to taką migrację :
[syntax=csharp]CreateTable(
"dbo.dictionaryslave",
c => new
{
ID = c.Int(nullable: false, identity: true),
DS_KEY = c.String(maxLength: 10, fixedLength: true, unicode: false, storeType: "char"),
DS_DESCRIPTION = c.String(maxLength: 50, storeType: "nvarchar"),
DS_VALUE1 = c.Decimal(precision: 11, scale: 2),
DS_VALUE2 = c.Decimal(precision: 11, scale: 2),
DS_DMID = c.Int(nullable: false),
})
.PrimaryKey(t => t.ID)
.ForeignKey("dbo.dictionarymaster", t => t.DS_DMID, cascadeDelete: true)
.Index(t => new { t.DS_DMID, t.DS_KEY }, unique: true, name: "IX_DmWithKey")
.Index(t => t.DS_KEY, name: "IX_Key")
.Index(t => t.DS_DESCRIPTION, name: "IX_Description");[/syntax]

Czy da się index IX_DmWithKey zrobić we FluentAPI bez tworzenia dodatkowych pól w klasie DictionarySlave? Od biedy mógłby być to klucz główny. Choć jak widać powyżej nie musi.
Oczywiście poniższe nie działa
[syntax=csharp]this.HasKey(e => new { e.DictionaryMaster, e.DictSlaveKey });
The property 'DictionaryMaster' cannot be used as a key property on the entity 'sopdmodel.Models.DictionarySlave' because the property type is not a valid key type. Only scalar types, string and byte[] are supported key types.

lub

this.HasKey(e => new { e.DictionaryMaster.Id, e.DictSlaveKey });
The properties expression 'e => new <>f__AnonymousTypea`2(Id = e.DictionaryMaster.Id, DictSlaveKey = e.DictSlaveKey)' is not valid. The expression should represent a property: C#: 't => t.MyProperty' VB.Net: 'Function(t) t.MyProperty'. When specifying multiple properties use an anonymous type: C#: 't => new { t.MyProperty1, t.MyProperty2 }' VB.Net: 'Function(t) New With { t.MyProperty1, t.MyProperty2 }'.[/syntax]

Statystyki: Napisane przez perlon — 27 paź 2016, o 11:40

Re: C# Entity Framework nazwa klucza obcego

2016-10-27T09:36:18+01:00

Wczoraj było już chyba za późno na myślenie. Ostateczna wersja która spełnia wymagania (he, he sam sobie odpowiadam, ale może przyda się to innym czytającym):
[syntax=csharp]namespace sopdmodel.Models
{
using RichardLawley.EF.AttributeConfig;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

[Table("dictionarymaster")]
public class DictionaryMaster
{
[Key]
[Column("ID")]
public int Id { get; set; }

[Column("DM_KEY", TypeName="char")]
[Index("IX_Key", IsUnique = true),StringLength(10)]
public string DictMasterKey { get; set; }

[Column("DM_DESCRIPTION", TypeName = "nvarchar")]
[Index("IX_Description"), StringLength(50)]
public string DictMasterDescription { get; set; }

[Column("DM_VALUE1")]
[DecimalPrecision(11, 2)]
public decimal? DictMasterValue1 { get; set; }

[Column("DM_VALUE2")]
[DecimalPrecision(11, 2)]
public decimal? DictMasterValue2 { get; set; }

public ICollection DictionarySlaves { get; set; }

}

[Table("dictionaryslave")]
public class DictionarySlave
{
[Key]
[Column("ID")]
public int Id { get; set; }

[Column("DS_KEY", TypeName = "char")]
[Index("IX_Key"), StringLength(10)]
public string DictSlaveKey { get; set; }

[Column("DS_DESCRIPTION", TypeName = "nvarchar")]
[Index("IX_Description"), StringLength(50)]
public string DictSlaveDescription { get; set; }

[Column("DS_VALUE1")]
[DecimalPrecision(11, 2)]
public decimal? DictSlaveValue1 { get; set; }

[Column("DS_VALUE2")]
[DecimalPrecision(11, 2)]
public decimal? DictSlaveValue2 { get; set; }

[ForeignKey("DictionaryMaster")]
[Column("DS_DMID")]
public int DictionaryMasterID { get; set; }

public DictionaryMaster DictionaryMaster { get; set; }
}
}[/syntax]

Daje to migrację dokłądnie taką o którą mi chodziło:

[syntax=csharp]public partial class DictMapp : DbMigration
{
public override void Up()
{
CreateTable(
"dbo.dictionarymaster",
c => new
{
ID = c.Int(nullable: false, identity: true),
DM_KEY = c.String(maxLength: 10, fixedLength: true, unicode: false, storeType: "char"),
DM_DESCRIPTION = c.String(maxLength: 50, storeType: "nvarchar"),
DM_VALUE1 = c.Decimal(precision: 11, scale: 2),
DM_VALUE2 = c.Decimal(precision: 11, scale: 2),
})
.PrimaryKey(t => t.ID)
.Index(t => t.DM_KEY, unique: true, name: "IX_Key")
.Index(t => t.DM_DESCRIPTION, name: "IX_Description");

CreateTable(
"dbo.dictionaryslave",
c => new
{
ID = c.Int(nullable: false, identity: true),
DS_KEY = c.String(maxLength: 10, fixedLength: true, unicode: false, storeType: "char"),
DS_DESCRIPTION = c.String(maxLength: 50, storeType: "nvarchar"),
DS_VALUE1 = c.Decimal(precision: 11, scale: 2),
DS_VALUE2 = c.Decimal(precision: 11, scale: 2),
DS_DMID = c.Int(nullable: false),
})
.PrimaryKey(t => t.ID)
.ForeignKey("dbo.dictionarymaster", t => t.DS_DMID, cascadeDelete: true)
.Index(t => t.DS_KEY, name: "IX_Key")
.Index(t => t.DS_DESCRIPTION, name: "IX_Description")
.Index(t => t.DS_DMID);

}

public override void Down()
{
DropForeignKey("dbo.dictionaryslave", "DS_DMID", "dbo.dictionarymaster");
DropIndex("dbo.dictionaryslave", new[] { "DS_DMID" });
DropIndex("dbo.dictionaryslave", "IX_Description");
DropIndex("dbo.dictionaryslave", "IX_Key");
DropIndex("dbo.dictionarymaster", "IX_Description");
DropIndex("dbo.dictionarymaster", "IX_Key");
DropTable("dbo.dictionaryslave");
DropTable("dbo.dictionarymaster");
}
}[/syntax]

To samo z FluentAPI. Przy okazji. Są jakieś argumenty za/przeciw FluentAPI? Czy może to tylko kwestia indywidualnych upodobań, bo klepania nieco więcej niż przy atrybutach.

[syntax=csharp]public class DictionaryMaster
{
public int Id { get; set; }

public string DictMasterKey { get; set; }

public string DictMasterDescription { get; set; }

[DecimalPrecision(11, 2)]
public decimal? DictMasterValue1 { get; set; }

[DecimalPrecision(11, 2)]
public decimal? DictMasterValue2 { get; set; }

public ICollection DictionarySlaves { get; set; }

}

public class DictionaryMasterMapping : EntityTypeConfiguration
{
public DictionaryMasterMapping()
: base()
{
// Mapping entity to datatable
this.HasKey(e => e.Id).Property(e => e.Id).HasColumnName("ID");
this.Property(e => e.DictMasterKey).HasMaxLength(10).HasColumnName("DM_KEY").HasColumnType("char");
this.Property(e => e.DictMasterDescription).HasMaxLength(50).HasColumnName("DM_DESCRIPTION").HasColumnType("nvarchar");
this.Property(e => e.DictMasterValue1).HasColumnName("DM_VALUE1");
this.Property(e => e.DictMasterValue2).HasColumnName("DM_VALUE2");

// Mapping indexes
this.Property(e => e.DictMasterKey).HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute("IX_Key") { IsUnique = true }));
this.Property(e => e.DictMasterDescription).HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute("IX_Description")));

// Mapping table
this.ToTable("dictionarymaster");
}
}

public partial class DictionarySlave
{
public int Id { get; set; }

public string DictSlaveKey { get; set; }

public string DictSlaveDescription { get; set; }

[DecimalPrecision(11, 2)]
public decimal? DictSlaveValue1 { get; set; }

[DecimalPrecision(11, 2)]
public decimal? DictSlaveValue2 { get; set; }

public DictionaryMaster DictionaryMaster { get; set; } //This is property in ForeignKey(PropertyName)
}

public class DictionarySlaveMapping : EntityTypeConfiguration
{
public DictionarySlaveMapping()
: base()
{
// Mapping entity
this.HasKey(e => e.Id).Property(e => e.Id).HasColumnName("ID");
this.Property(e => e.DictSlaveKey).HasMaxLength(10).HasColumnName("DS_KEY").HasColumnType("char");
this.Property(e => e.DictSlaveDescription).HasMaxLength(50).HasColumnName("DS_DESCRIPTION").HasColumnType("nvarchar");
this.Property(e => e.DictSlaveValue1).HasColumnName("DS_VALUE1");
this.Property(e => e.DictSlaveValue2).HasColumnName("DS_VALUE2");

// Mapping indexes
this.Property(e => e.DictSlaveKey).HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute("IX_Key")));
this.Property(e => e.DictSlaveDescription).HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute("IX_Description")));

// Mapping relations
this.HasRequired(e => e.DictionaryMaster).WithMany(s => s.DictionarySlaves).Map(p => p.MapKey("DS_DMID")).WillCascadeOnDelete();

// Mapping table
this.ToTable("dictionaryslave");
}
}[/syntax]

Statystyki: Napisane przez perlon — 27 paź 2016, o 09:36

Re: C# Entity Framework nazwa klucza obcego

2016-10-26T14:44:50+01:00

Czytałem wcześniej podany przez ciebie wpis ale chyba go nie zrozumiałem. Przeczytałem więc go jeszcze dwa razy i załapałem. Problemem było myślowe przejście z modelu relacyjne na model obiektowy i co się tam dzieje. Dzięki zadziałało podejście 1.2 [syntax=csharp][Table("dictionaryslave")]
public partial class DictionarySlave
{
[Key]
public int Id { get; set; }

[Column("DS_KEY", TypeName = "char")]
[Index("IX_Key"), StringLength(10)]
public string DictSlaveKey { get; set; }

[Column("DS_DESCRIPTION", TypeName = "nvarchar")]
[Index("IX_Description"), StringLength(50)]
public string DictSlaveDescription { get; set; }

[Column("DS_VALUE1")]
[DecimalPrecision(11, 2)]
public decimal? DictSlaveValue1 { get; set; }

[Column("DS_VALUE2")]
[DecimalPrecision(11, 2)]
public decimal? DictSlaveValue2 { get; set; }

[ForeignKey("DictionaryMaster")] //Has to be a property name, not table column name
[Column("DS_DMID")]
public int DictionaryMasterId { get; set; }

public DictionaryMaster DictionaryMaster { get; set; }
}[/syntax]

no i migracja wygląda już tak jak chciałem
[syntax=csharp]CreateTable(
"dbo.dictionarymaster",
c => new
{
Id = c.Int(nullable: false, identity: true),
DM_KEY = c.String(maxLength: 10, fixedLength: true, unicode: false, storeType: "char"),
DM_DESCRIPTION = c.String(maxLength: 50, storeType: "nvarchar"),
DM_VALUE1 = c.Decimal(precision: 11, scale: 2),
DM_VALUE2 = c.Decimal(precision: 11, scale: 2),
})
.PrimaryKey(t => t.Id)
.Index(t => t.DM_KEY, name: "IX_Key")
.Index(t => t.DM_DESCRIPTION, name: "IX_Description");

CreateTable(
"dbo.dictionaryslave",
c => new
{
Id = c.Int(nullable: false, identity: true),
DS_KEY = c.String(maxLength: 10, fixedLength: true, unicode: false, storeType: "char"),
DS_DESCRIPTION = c.String(maxLength: 50, storeType: "nvarchar"),
DS_VALUE1 = c.Decimal(precision: 11, scale: 2),
DS_VALUE2 = c.Decimal(precision: 11, scale: 2),
DS_DMID = c.Int(nullable: false),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.dictionarymaster", t => t.DS_DMID, cascadeDelete: true)
.Index(t => t.DS_KEY, name: "IX_Key")
.Index(t => t.DS_DESCRIPTION, name: "IX_Description")
.Index(t => t.DS_DMID);[/syntax]

Jak będzie szło pobieranie danych to się niebawem okaże. Na razie dzięki za podpowiedź.

Po walce z FluentAPI wyszło mi takie cość
[syntax=csharp]namespace sopdmodel.Models
{
using RichardLawley.EF.AttributeConfig;
using System.Data.Entity.Infrastructure.Annotations;
using System.Data.Entity.ModelConfiguration;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

[Table("dictionaryslave")]
public partial class DictionarySlave
{
// [Key]
public int Id { get; set; }

//[Column("DS_KEY", TypeName = "char")]
//[Index("IX_Key"), StringLength(10)]
public string DictSlaveKey { get; set; }

//[Column("DS_DESCRIPTION", TypeName = "nvarchar")]
//[Index("IX_Description"), StringLength(50)]
public string DictSlaveDescription { get; set; }

// [Column("DS_VALUE1")]
[DecimalPrecision(11, 2)]
public decimal? DictSlaveValue1 { get; set; }

// [Column("DS_VALUE2")]
[DecimalPrecision(11, 2)]
public decimal? DictSlaveValue2 { get; set; }

//[ForeignKey("DictionaryMaster")] //Has to be a property name, not table column name
//[Column("DS_DMID")]
public int DictionaryMasterId { get; set; }

public DictionaryMaster DictionaryMaster { get; set; }
}

public class DictionarySlaveMapping : EntityTypeConfiguration
{
public DictionarySlaveMapping()
: base()
{
// Mapping entity to datatable
this.HasKey(e => e.Id).Property(e => e.Id).HasColumnName("ID");
this.Property(e => e.DictSlaveKey).HasColumnName("DS_KEY");
this.Property(e => e.DictSlaveDescription).HasColumnName("DS_DESCRIPTION");
this.Property(e => e.DictSlaveValue1).HasColumnName("DS_VALUE1");
this.Property(e => e.DictSlaveValue2).HasColumnName("DS_VALUE2");
// Mapping indexes
this.Property(e => e.DictSlaveKey).HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute("IX_Key") { IsUnique = true }));
this.Property(e => e.DictSlaveDescription).HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute("IX_Description")));
// Mapping relations
this.HasRequired(e => e.DictionaryMaster).WithMany(s => s.DictionarySlaves).HasForeignKey(s => s.DictionaryMasterId).WillCascadeOnDelete();
// .Map(p => p.MapKey("DS_DMID")
this.ToTable("dictionaryslave");
}
}[/syntax]
[syntax=csharp]CreateTable(
"dbo.dictionaryslave",
c => new
{
ID = c.Int(nullable: false, identity: true),
DS_KEY = c.String(unicode: false),
DS_DESCRIPTION = c.String(unicode: false),
DS_VALUE1 = c.Decimal(precision: 11, scale: 2),
DS_VALUE2 = c.Decimal(precision: 11, scale: 2),
DictionaryMasterId = c.Int(nullable: false),
})
.PrimaryKey(t => t.ID)
.ForeignKey("dbo.dictionarymaster", t => t.DictionaryMasterId, cascadeDelete: true)
.Index(t => t.DS_KEY, unique: true, name: "IX_Key")
.Index(t => t.DS_DESCRIPTION, name: "IX_Description")
.Index(t => t.DictionaryMasterId);[/syntax]
Tylko jak zmapować DictionaryMasterId na kolumnę DS_DMID
Mogę zrobić tak ale to jest jakaś masakra.
[syntax=csharp]//[ForeignKey("DictionaryMaster")] //Has to be a property name, not table column name
//[Column("DS_DMID")]
public int DS_DMID { get; set; }

public DictionaryMaster DictionaryMaster { get; set; }

this.HasRequired(e => e.DictionaryMaster).WithMany(s => s.DictionarySlaves).HasForeignKey(s => s.DS_DMID).WillCascadeOnDelete();[/syntax]

Statystyki: Napisane przez perlon — 26 paź 2016, o 14:44

Re: C# Entity Framework nazwa klucza obcego

2016-10-26T13:00:23+01:00

Dawno temu bawilem sie EF - ale Tak na szybko rzuc okiem http://stackoverflow.com/a/11148834/2476347 uzywajac wlasnie tego podejscia powienenes osiagnac co potrzebujesz.

Daj znac czy cos pomoglo a jak nie to postaram sie cos wiecej zrobic jak bede pozniej w domu

Statystyki: Napisane przez RafPe — 26 paź 2016, o 13:00

C# Entity Framework nazwa klucza obcego

2016-10-26T12:54:21+01:00

Witam.
Na początek zaznaczam, że jestem bardzo początkujący w temacie dlatego proszę o wyrozumiałość.
Piszę programik z EF6 Code First. Mam Dwie klasy DictionaryMaster i DictionarySlave. Jak się można domyśleć są powiązane relacją 1+M. Ppotrzebuję ustawić konkretną moją nazwę pola obsługującego relacje. O co dokładnie chodzi wyjaśniam w dalszej części.

Klasy wyglądają następująco
[syntax=csharp]namespace sopd2.Models
{
using RichardLawley.EF.AttributeConfig;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

[Table("dictionarymaster")]
public class DictionaryMaster
{
[Key]
public int ID { get; set; }

[Column("DM_KEY", TypeName="char")]
[Index("IX_Key"),StringLength(10)]
public string DictMasterKey { get; set; }

[Column("DM_DESCRIPTION", TypeName = "nvarchar")]
[Index("IX_Description"), StringLength(50)]
public string DictMasterDescription { get; set; }

[Column("DM_VALUE1")]
[DecimalPrecision(11, 2)]
public decimal? DictMasterValue1 { get; set; }

[Column("DM_VALUE2")]
[DecimalPrecision(11, 2)]
public decimal? DictMasterValue2 { get; set; }

public ICollection DictionarySlaves { get; set; }

}

[Table("dictionaryslave")]
public partial class DictionarySlave
{
[Key]
public int ID { get; set; }

[Column("DS_KEY", TypeName = "char")]
[Index("IX_Key"), StringLength(10)]
public string DictSlaveKey { get; set; }

[Column("DS_DESCRIPTION", TypeName = "nvarchar")]
[Index("IX_Description"), StringLength(50)]
public string DictSlaveDescription { get; set; }

[Column("DS_VALUE1")]
[DecimalPrecision(11, 2)]
public decimal? DictSlaveValue1 { get; set; }

[Column("DS_VALUE2")]
[DecimalPrecision(11, 2)]
public decimal? DictSlaveValue2 { get; set; }

}
}[/syntax]

Migracja tworzy mi następujący kod tworzący tabele
[syntax=csharp]namespace sopd2.Migrations
{
using System;
using System.Data.Entity.Migrations;

public partial class des01 : DbMigration
{
public override void Up()
{
CreateTable(
"dbo.dictionarymaster",
c => new
{
ID = c.Int(nullable: false, identity: true),
DM_KEY = c.String(maxLength: 10, fixedLength: true, unicode: false, storeType: "char"),
DM_DESCRIPTION = c.String(maxLength: 50, storeType: "nvarchar"),
DM_VALUE1 = c.Decimal(precision: 11, scale: 2),
DM_VALUE2 = c.Decimal(precision: 11, scale: 2),
})
.PrimaryKey(t => t.ID)
.Index(t => t.DM_KEY, name: "IX_Key")
.Index(t => t.DM_DESCRIPTION, name: "IX_Description");

CreateTable(
"dbo.dictionaryslave",
c => new
{
ID = c.Int(nullable: false, identity: true),
DS_KEY = c.String(maxLength: 10, fixedLength: true, unicode: false, storeType: "char"),
DS_DESCRIPTION = c.String(maxLength: 50, storeType: "nvarchar"),
DS_VALUE1 = c.Decimal(precision: 11, scale: 2),
DS_VALUE2 = c.Decimal(precision: 11, scale: 2),
DictionaryMaster_ID = c.Int(),
})
.PrimaryKey(t => t.ID)
.ForeignKey("dbo.dictionarymaster", t => t.DictionaryMaster_ID)
.Index(t => t.DS_KEY, name: "IX_Key")
.Index(t => t.DS_DESCRIPTION, name: "IX_Description")
.Index(t => t.DictionaryMaster_ID);

}

public override void Down()
{
DropIndex("dbo.dictionaryslave", new[] { "DictionaryMaster_ID" });
DropIndex("dbo.dictionaryslave", "IX_Description");
DropIndex("dbo.dictionaryslave", "IX_Key");
DropIndex("dbo.dictionarymaster", "IX_Description");
DropIndex("dbo.dictionarymaster", "IX_Key");
}
}
}[/syntax]

Jak widać w tabeli 'dictionaryslave' niejako od zaplecza zostało stworzone pole 'DictionaryMaster_ID' jako klucz obcy do obsługi relacji 1+M. Widać również że jego nazwa nie pasuje do przyjętej konwencji nazewnictwa kolumn w tabeli. Chciałbym je ustawić na 'DS_DMID'. Próbowałem zdefiniować kolejną właściwość w klasie DictionarySlave ale nie udało mi się jej podpiąć jako ForeinKey
[syntax=csharp][ForeignKey("DS_DMID")]
public int DictMasterID { get; set; }[/syntax]

Mam inny zestaw klas z relacją M+N i poradziłem sobie z podobnym tematem następująco :
[syntax=csharp][Table("users")]
public partial class User
{
[Key]
public int ID { get; set; }

[Column("US_LOGIN", TypeName = "char")]
[Required]
[StringLength(10)]
public string Login { get; set; }

[Column("US_NAME",TypeName = "nvarchar")]
[Required]
[StringLength(30)]
public string SurName { get; set; }

[Column("US_FNAME", TypeName = "nvarchar")]
[Required]
[StringLength(30)]
public string FirstName { get; set; }

[Column("US_EMAIL", TypeName = "nvarchar")]
[Required]
[StringLength(30)]
public string Email { get; set; }

[Column("US_TIMESTAMP")]
public DateTime? TimeStamp { get; set; }

[Column("US_PRIVILEGE", TypeName = "bigint")]
public long Privilege { get; set; }

[Column("US_HASH", TypeName = "char")]
[StringLength(50)]
public string Hash { get; set; }

public virtual ICollection UserGroups { get; set; }
}

[Table("usergroups")]
public partial class UserGroup
{
[Key]
public int ID { get; set; }

[Column("UG_NAME", TypeName = "nvarchar")]
[Required]
[Index("IX_Name"), StringLength(50)]
public string UserGroupName { get; set; }

public ICollection Users { get; set; }
}[/syntax]

I w metodzie OnModelCreating coś takiego co załatwia mi zmianę nazwy tabeli jak również własne nazwy kolumn i gitara. Mniej więcej rozumiem co poniższe robi ale niestety nie potrafię poniższego zaimplementować w tabeli podrzędnej DictionarySlave w relacji 1+M.

[syntax=csharp]protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);

modelBuilder.Conventions.Remove();
// Add conventions for Precision Attributes
modelBuilder.Conventions.Add(new DecimalPrecisionAttributeConvention());
modelBuilder.Conventions.Add(new DateTimePrecisionAttributeConvention());

modelBuilder.Entity().HasMany(x => x.UserGroups).WithMany(y => y.Users)
.Map(m =>
{
m.ToTable("usergroupmembers");
m.MapLeftKey("GM_USID");
m.MapRightKey("GM_GRID");
});
}[/syntax]

Statystyki: Napisane przez perlon — 26 paź 2016, o 12:54