Entity Framework 6 where did key and column attributes go

c# ef-code-first entity-framework entity-framework-6 entity-framework-6.1

Question

I'm upgrading from Entity Framework 4.1.0.0 to Entity Framework 6 and I'm having a really hard time tracking where all of the old classes went and what namespace things are in these days.

I've got a class that looks like this and was using these attributes but now I

[Key, Column(Order = 1)]
public int PersonID { get; set; }
[Key, Column(Order = 2)]
public int WorkoutID { get; set; }
etc...
  1. Can't figure out what namespace the attributes are in
  2. Even figure out if I'm supposed to be using them
  3. Can't nuke the EF class lib and rebuild it because the DB is code-first - I think..
    1. Disclaimer: I've never really worked from code-first because I like being able to rebuild my edmx file from scratch

Can anyone point me in the right direction? MSDN docs have some up short, the EF 6 upgrade guide (found here: http://visualstudiomagazine.com/articles/2014/03/01/whats-new-in-entity-framework-6.aspx) doesn't contain what I need and you'll all my last hope (not really - I'll keep looking no matter what)

1
2
7/25/2014 12:41:31 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

I am not sure that I understand your question, but all of EF6 CF attributes are in : System.ComponentModel.DataAnnotations

you can find more here:

System.ComponentModel.DataAnnotations Namespace ()

3
7/25/2014 3:32:32 AM

Popular Answer

The attributes dealing with database schema moved to: System.ComponentModel.DataAnnotations.Schema Namespace.

That's why they may appear missing when you upgraded, but just adding that namespace to your code file will get things back working.

Pedro Silva

Related Questions

Entity Framework Code First Using One column as Primary Key and another as Auto Increment Column

Apparently the ...answer... of @IronMan84 correct. But it didn't work for me. I slightly modified it to apply my another condition. And it worked. I did nothing else....This is my solution....public class Sale { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } [Key, Column(TypeName = "varchar"), MaxLeng...
c# ef-code-first entity-framework
asked by Seevali H Rathnayake

How to create Unique key for a varchar column for entity framework database?

say If you create this table ...CREATE TABLE ConstTable (ID INT, Email VARCHAR(1000) CONSTRAINT uc_Email UNIQUE (Email) ) GO ...you will get a warning :...Warning! The maximum key length is 900 bytes. The index 'uc_Email' has maximum length of 1000 bytes. For some combination of large values, the insert/update operation will fail...Your colum...
entity-framework sql sql-server unique
asked by M.Ali

Entity Framework Foreign Key attribute usage problems

Some weeks ago I found conflicting information regarding the use of the ForeignKey attribute so I stuck with the one that seemed most logical....However, I did another experiment and then moved the ForeignKey attribute to the ...CountryCode... property of the ...Currency... table/model as follows:... [Key] [ForeignKey("Country")] [StringLength(2)...
ef-code-first ef-migrations entity-framework-6
asked by Lord of Scripts

Entity framework composite primary key - how to get order of columns

Not need to Add code as this...// Primary Key this.HasKey(t => new { t.Id, t.BarId }); ...Only user...// Primary Key this.HasKey(t =>t.Id );
c# entity-framework-5 entity-framework-6
asked by Saneesh kunjunni

Can a foreign key column be an Enum in Entity Framework 6 code first?

I just ran into this same issue with my enum being a basic number enum, but this came up as the first result in the search by message. I had a subtype on my main object where the values were of a fixed set of values. But, there were also objects for those so we could write queries against them....public class Foo { [Key] public int Id { get...
c# entity-framework-6 enums foreign-keys
asked by krillgar

Update Database using Entity Framework having primary key on multiple Columns

For me, the problem was Unique Index on some of the columns in my database. Violating the index was causing this error to be displayed....But when I was searching for the solution I found there can be other reasons for this error also , like make sure key have values and are not null , check concurrence setting for the column .
asp.net-mvc asp.net-mvc-4 c# entity-framework linq
asked by Danish Shaikh

Composite Key and using Multiple Column Attributes in Entity Framework 6

Since your ...Drivers... table's Primary Key is now ...(DriverId, Type)..., you can no longer reference your drivers by ...DriverId... alone - you must reference them by both ...DriverId... and ...Type.... Therefore, your ...DriversToVehicle... table needs to look something like this:...public partial class DriversToVehicle { [Column("id"), Key...
c# entity-framework entity-framework-6
asked by Rich Turner

Entity Framework 6 creates Id column even though other primary key is defined

I suspect it has something to do with the fact that you are deriving your class from ...EntityData... and ...EntityData... has a property named ...Id.... My guess is that EF is getting confused because there is a property which adheres to it's key naming conventions (i.e. ...Id...) and an explicitly defined key....I suspect you'll have to tell it ...
c# data-annotations ef-fluent-api entity-framework entity-framework-6
asked by John Laffoon

Entity Framework 6 is not mapping my columns correctly using Attributes

Your ...Column... attribute will be ignored if you are using custom ...SqlQuery<T>... on the ...DbContext.... You need to pass the Sql statement with the alias for the property name that matches your entity. ...var t = this.Database.SqlQuery<InventoryDb>("select top 100 Item_QTY as [ItemQuantity], ... other columns ... from COMPANY_INVENTORY with (...
.net c# entity-framework entity-framework-6
asked by Vidmantas Blazevicius

Entity framework 6, fluent mapping of 1 to 0..1 relationship on non-primary-key columns

Remove the...HasOptional(Function(x) x.AddressDetails).WithRequired(Function(x) x.BookingLeg).Map(Function(x) x.MapKey("Prefix", "ID")) ...line from ...BookingLegConfig... class. Every single relationships must be configured only once in a single place (part of the configuration of any of the two involved entities, but not in both). In this particu...
dbcontext entity-framework-6
asked by Ivan Stoev

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow