StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to configure multiple Foreignkey referancing to same table from main table using EF Code First Fluient API
primarykey
Id
6660067
data
AcceptedAnswerId
0
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-07-12T05:59:41.290
FavoriteCount
2
LastActivityDate
2011-07-12T11:23:59.683
LastEditDate
2011-07-12T07:52:47.793
LastEditorUserId
413501
OwnerUserId
840003
ParentId
0
PostTypeId
1
Score
2
ViewCount
1018
LastEditorDisplayName
text
Body
<p>I have to design a web application using existing database of desktop application. As per existing database i have below class</p> <pre><code>public class Company { #region Primitive Properties public virtual int CompanyID { get; set; } public virtual string CompanyName { get; set; } public virtual bool IsCustomer { get; set; } public virtual string CustomerCode { get; set; } public virtual bool IsPotentialCustomer { get; set; } public virtual bool IsSupplier { get; set; } public virtual string SupplierCode { get; set; } public virtual bool IsPotentialSupplier { get; set; } public CompanyCategoryCodes CustomerCategoryCode { get; set; } public CompanyCategoryCodes SupplierCategoryCode { get; set; } public CountryCode CountryCode { get; set; } } public class CompanyCategoryCodes { public virtual int CategoryID { get; set; } public virtual string CategoryCodes { get; set; } public virtual bool PotentialCustomer { get; set; } public virtual bool PotentialSupplier { get; set; } public virtual System.DateTime LastModifiedDate { get; set; } public virtual bool Manufacturer { get; set; } } public class CountryCode { public virtual int CountryCodeID { get; set; } public virtual string Code { get; set; } public virtual string Description { get; set; } public virtual bool DefaultCode { get; set; } public virtual bool EECVATApplies { get; set; } public virtual System.DateTime LastModifiedDate { get; set; } public virtual bool FixedAddressFormat { get; set; } } </code></pre> <p>EF Code first default framework is creating Foreignkey with name "CustomerCategoryCode_CategoryID" , "SupplierCategoryCode_CategoryID", "CountryCode_CountryCodeID". I want this Foreignkey name to be consistance with my old database tables e.g. "CustomerCategoryCodeID", "SupplierCategoryCodeID", "CountryCodeID". How can i do it using EF Code First Fluient API. I try to do it using Fluient API Mapping but i got error for "SupplierCategoryCode_CategoryCodeID" as "CustomerCategoryCode_CategoryID" is also locating to same table "CompanyCategoryCode". Also if is there any option available using Data Annotation then also let me know how to achieve this.</p>
Tags
<asp.net><entity-framework-4.1><code-first>
Title
How to configure multiple Foreignkey referancing to same table from main table using EF Code First Fluient API
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USLadislav Mrnka
UserOwnerUserId
1. USAnand Patel
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.