StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow do I properly get the entity framework to use my composite primary key?
primarykey
Id
15101960
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-02-27T00:16:40.267
FavoriteCount
0
LastActivityDate
2013-02-27T00:55:09.313
LastEditDate
2013-02-27T00:55:09.313
LastEditorUserId
2005463
OwnerUserId
2005463
ParentId
0
PostTypeId
1
Score
1
ViewCount
252
LastEditorDisplayName
text
Body
I have a table defined as such: <pre><code>CREATE TABLE [dbo].[Sitemap]( [EntityId] [int] NOT NULL, [PageUrl] [nvarchar](400) NOT NULL, [Frequency] [nvarchar](400) NOT NULL, [PageType] [nvarchar](400) NOT NULL, [UpdatedOn] [datetime] NOT NULL, CONSTRAINT [PK_Sitemap] PRIMARY KEY CLUSTERED ( [EntityId] ASC, [PageType] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] </code></pre> I went to my edmx file and did an update from database. It imported everything but didn't mark both fields as a primary key. I tried added the second field as a primary key, but it still won't treat them as composites. The issue I am having is when I run an update at the table that has a similar entry such as EntityId = 1, PageType = 'Product',.... and EntityId = 1, PageType = 'Artist',... I am getting an error saying: An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key. How do I get my Model or code to properly use the composite as the primary key? Or do I have to make some kind of composite field to do this? UPDATE My Code is a fork from NopCommerce 1.90 As such I have added an interface and service and registered that with the IoC resolver. I have the following class that for this table: <pre><code>//------------------------------------------------------------------------------ // The contents of this file are subject to the nopCommerce Public License Version 1.0 ("License"); you may not use this file except in compliance with the License. // You may obtain a copy of the License at http://www.nopCommerce.com/License.aspx. // // Software distributed under the License is distributed on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. // See the License for the specific language governing rights and limitations under the License. // // The Original Code is nopCommerce. // The Initial Developer of the Original Code is NopSolutions. // All Rights Reserved. // // Contributor(s): _______. //------------------------------------------------------------------------------ using System; using System.Collections.Generic; using System.Diagnostics; using System.Globalization; using NopSolutions.NopCommerce.BusinessLogic.CustomerManagement; using NopSolutions.NopCommerce.BusinessLogic.Infrastructure; using NopSolutions.NopCommerce.BusinessLogic.Payment; using NopSolutions.NopCommerce.BusinessLogic.Promo.Affiliates; using NopSolutions.NopCommerce.BusinessLogic.Promo.Discounts; using NopSolutions.NopCommerce.BusinessLogic.Shipping; using NopSolutions.NopCommerce.BusinessLogic.Tax; namespace NopSolutions.NopCommerce.BusinessLogic.SEO.Sitemaps { /// <summary> /// Represents a Sitemap /// </summary> [Serializable] public partial class Sitemap : BaseEntity { #region Utilities #endregion #region Properties /// <summary> /// Gets or Sets EntityId (Product ID, Show ID, etc.) /// </summary> public int EntityId { get; set; } /// <summary> /// Gets or sets the Page Url /// </summary> public string PageUrl { get; set; } /// <summary> /// Gets of set the Page Frequency (Should be one of the following - Always, Hourly, Daily, Weekly, Monthly, Yearly, Never) /// </summary> public string Frequency { get; set; } /// <summary> /// Gets or sets the page type. For example: Product, or Show /// </summary> public string PageType { get; set; } /// <summary> /// Gets or sets the date and time of sitemap entry update /// </summary> public DateTime UpdatedOn { get; set; } #endregion } } </code></pre> Then I have the interface and service: Interface: <pre><code> //------------------------------------------------------------------------------ // The contents of this file are subject to the nopCommerce Public License Version 1.0 ("License"); you may not use this file except in compliance with the License. // You may obtain a copy of the License at http://www.nopCommerce.com/License.aspx. // // Software distributed under the License is distributed on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. // See the License for the specific language governing rights and limitations under the License. // // The Original Code is nopCommerce. // The Initial Developer of the Original Code is NopSolutions. // All Rights Reserved. // // Contributor(s): _______. //------------------------------------------------------------------------------ using System; using System.Collections.Generic; using NopSolutions.NopCommerce.BusinessLogic.CustomerManagement; using NopSolutions.NopCommerce.BusinessLogic.Payment; using NopSolutions.NopCommerce.BusinessLogic.Shipping; using NopSolutions.NopCommerce.Common; namespace NopSolutions.NopCommerce.BusinessLogic.SEO.Sitemaps { /// <summary> /// Sitemap service /// </summary> public partial interface ISiteMapService { /// <summary> /// Gets a Sitemap entry based on url. /// </summary> /// <param name="url">Fully Qualified URL (e.g. http://www.onlinesheetmusic.com/default.aspx)</param> /// <returns></returns> Sitemap GetSitemap(string url); /// <summary> /// Gets the most recent entry to the sitemap table /// </summary> /// <returns></returns> Sitemap GetLastAddedSitemap(string pageType); /// <summary> /// Gets a list of Sitemap entries that are in the init state of the given Page Type /// </summary> /// <param name="pageType">Page Type</param> /// <returns></returns> List<Sitemap> GetInitEntries(string pageType); /// <summary> /// Bool to determine if a given pageType has any entries in the init state. /// </summary> /// <param name="pageType"></param> /// <returns></returns> bool IsInit(string pageType); void InitSitemap(string pageType, int startProdId = 0); /// <summary> /// Inserts a sitemap entry /// </summary> /// <param name="order">Order</param> void InsertSitemap(Sitemap sm); /// <summary> /// Updates the order /// </summary> /// <param name="order">The order</param> void UpdateSitemap(Sitemap sm); } } </code></pre> Service: <pre><code>//------------------------------------------------------------------------------ // The contents of this file are subject to the nopCommerce Public License Version 1.0 ("License"); you may not use this file except in compliance with the License. // You may obtain a copy of the License at http://www.nopCommerce.com/License.aspx. // // Software distributed under the License is distributed on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. // See the License for the specific language governing rights and limitations under the License. // // The Original Code is nopCommerce. // The Initial Developer of the Original Code is NopSolutions. // All Rights Reserved. // // Contributor(s): _______. //------------------------------------------------------------------------------ using System; using System.Collections.Generic; using System.Globalization; using System.Linq; using System.Text; using NopSolutions.NopCommerce.BusinessLogic.Audit; using NopSolutions.NopCommerce.BusinessLogic.Caching; using NopSolutions.NopCommerce.BusinessLogic.Configuration.Settings; using NopSolutions.NopCommerce.BusinessLogic.CustomerManagement; using NopSolutions.NopCommerce.BusinessLogic.Data; using NopSolutions.NopCommerce.BusinessLogic.Directory; using NopSolutions.NopCommerce.BusinessLogic.Infrastructure; using NopSolutions.NopCommerce.BusinessLogic.Localization; using NopSolutions.NopCommerce.BusinessLogic.Messages; using NopSolutions.NopCommerce.BusinessLogic.Messages.SMS; using NopSolutions.NopCommerce.BusinessLogic.Payment; using NopSolutions.NopCommerce.BusinessLogic.Products; using NopSolutions.NopCommerce.BusinessLogic.Products.Attributes; using NopSolutions.NopCommerce.BusinessLogic.Profile; using NopSolutions.NopCommerce.BusinessLogic.Promo.Discounts; using NopSolutions.NopCommerce.BusinessLogic.QuickBooks; using NopSolutions.NopCommerce.BusinessLogic.Security; using NopSolutions.NopCommerce.BusinessLogic.Shipping; using NopSolutions.NopCommerce.BusinessLogic.Tax; using NopSolutions.NopCommerce.Common; using NopSolutions.NopCommerce.Common.Extensions; using NopSolutions.NopCommerce.Common.Utils; using NopSolutions.NopCommerce.Common.Utils.Html; namespace NopSolutions.NopCommerce.BusinessLogic.SEO.Sitemaps { /// <summary> /// Sitemap service /// </summary> public partial class SiteMapService : ISiteMapService { #region Fields /// <summary> /// Object context /// </summary> private readonly NopObjectContext _context; /// <summary> /// Cache service /// </summary> private readonly ICacheManager _cacheManager; #endregion Fields #region Ctor /// <summary> /// Ctor /// </summary> /// <param name="context">Object context</param> public SiteMapService(NopObjectContext context) { this._context = context; this._cacheManager = new NopRequestCache(); } #endregion Ctor #region Utilities #endregion Utilities #region Methods /// <summary> /// Gets a sitemap entry /// </summary> /// <param name="url">The url of the sitempa item</param> /// <returns>Order</returns> public Sitemap GetSitemap(string url) { if (!url.IsNotNullOrEmpty()) return null; var query = from sm in _context.Sitemaps where sm.PageUrl.Contains(url) select sm; var sitemap = query.SingleOrDefault(); return sitemap; } public Sitemap GetLastAddedSitemap(string pageType) { var query = (from sm in _context.Sitemaps where sm.PageType.Equals(pageType) orderby sm.UpdatedOn descending select sm).Take(1); var sitemap = query.SingleOrDefault(); return sitemap; } public List<Sitemap> GetInitEntries(string pageType) { var query = (from sm in _context.Sitemaps where sm.PageType.Equals(pageType) && sm.Frequency == "Init" select sm).Take(500); return query.ToList(); } /// <summary> /// Bool to check if a given type has any entries in the init state. /// </summary> /// <param name="pageType">Page Type</param> /// <returns>True or False</returns> public bool IsInit(string pageType) { var query = (from sm in _context.Sitemaps where sm.PageType.Equals(pageType) && sm.PageUrl.Equals("Init") select sm).Take(1); if (query == null) return true; else return false; } public void InitSitemap(string pageType, int startProdId = 0) { _context.Sp_SitemapInit(pageType, startProdId); } /// <summary> /// Inserts a sitemap entry /// </summary> /// <param name="sm">Sitemap Entry to Insert</param> public void InsertSitemap(Sitemap sm) { if (sm == null) throw new ArgumentNullException("sitemap"); sm.PageUrl = CommonHelper.EnsureNotNull(sm.PageUrl); sm.PageType = CommonHelper.EnsureNotNull(sm.PageType); sm.Frequency = CommonHelper.EnsureNotNull(sm.Frequency); _context.Sitemaps.AddObject(sm); _context.SaveChanges(); } /// <summary> /// Updates a sitemap entry /// </summary> /// <param name="sm">Sitemap Entry to update</param> public void UpdateSitemap(Sitemap sm) { if (sm == null) throw new ArgumentNullException("sitemap"); sm.PageUrl = CommonHelper.EnsureNotNull(sm.PageUrl); sm.PageType = CommonHelper.EnsureNotNull(sm.PageType); sm.Frequency = CommonHelper.EnsureNotNull(sm.Frequency); if(_context.Sitemaps.Any(s => (s.PageUrl == sm.PageUrl || s.EntityId == sm.EntityId))) { if (!_context.IsAttached(sm)) _context.Sitemaps.Attach(sm); } else { _context.Sitemaps.AddObject(sm); } _context.SaveChanges(); } #endregion Methods #region Properties /// <summary> /// Gets a value indicating whether cache is enabled /// </summary> public bool CacheEnabled { get { return IoC.Resolve<ISettingManager>().GetSettingValueBoolean("Cache.OrderManager.CacheEnabled"); } } #endregion Properties } } </code></pre> When I call <pre><code>var sitemapservice = IoC.Resolve<ISiteMapService>(); sitemapservice.InitSitemap("Artist"); var smEntries = sitemapservice.GetInitEntries("Artist"); foreach (Sitemap sm in smEntries) { using (MvcMiniProfiler.MiniProfiler.StepStatic("Processing Entry: " + sm.EntityId + "," + sm.PageType)) { sm.Frequency = "Monthly"; sm.PageUrl = SEOHelper.GetUrl(this.ArtistService.GetArtistById(sm.EntityId), this.SettingManager.StoreUrl); using (MvcMiniProfiler.MiniProfiler.StepStatic("Updating database")) { sitemapservice.UpdateSitemap(sm); } curCount++; } } </code></pre> It is supposed to get all the entries that are in the init stage and set them up with the correct url, but for whatever reason I keep getting errors saying An object with the same key already exists in the ObjectStateManager. Though the strange thing is the DB seems to be updating properly it just keeps giving me this error.
Tags
<asp.net><sql-server-2008><entity-framework>
Title
How do I properly get the entity framework to use my composite primary key?
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. UStim95030
UserOwnerUserId
1. UStim95030
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POHow do I properly get the entity framework to use my composite primary key?
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
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.