Linq to entities insert problem – make sure the qualifiedEntitySetName is correct

After drinking cold coffee in agony for 24 hours over the Insert functionality in Linq to Entities, I finally stumbled up on a good solution.  I had been getting errors like ..  “The member with identity ‘Entities’ does not exist in the metadata collection. Parameter name: identity” in the Context.AddObject() method.

First of all I found the core place to be for my concerns and questions. The ADO.Net forum and then I found this post which really got me on the track.

Ended up solving all my problems with the following when inserting an object with 2 foreign keys;  Course and User which are of types (Course and User);  for which I don’t want to retrieve the objects from the database just to add them as the foreign keys for the insert.  The eventual solution for the insert looks like this (with the root problem bolded).

public void InsertRound(Round round)

{

round.UserReference.EntityKey = new EntityKey(DBContext.DefaultContainerName + “.User”, “Id”, round.IdUser);

round.CourseReference.EntityKey = new EntityKey(DBContext.DefaultContainerName + “.Course”, “Id”, round.IdCourse);

DB.AddToRound(round);

DB.SaveChanges();

}

You know that you are having fun programming …

… when the coffee turns cold before you have time to have a sip.

.. and you are having too much fun when you drink that cold cup of coffee because you don’t want to spend time away from the code to get another (hot) one  :)

Dynamic Linq to Entities – using Like conditions

I have been using L2E for a while, and I am pleasantly surprised with what I have seen so far.  Today I ran into one of the expected walls, building dynamic queries (based on incoming request params).  Finding a solution to this I stumbled onto Dynamic Linq.

• http://weblogs.asp.net/scottgu/archive/2008/01/07/dynamic-linq-part-1-using-the-linq-dynamic-query-library.aspx
• http://www.west-wind.com/Weblog/posts/143814.aspx
• http://naspinski.net/post/Writing-Dynamic-Linq-Queries-in-Linq-to-Entities.aspx

Having downloaded a single class implementation for the dynamic part.  There I ran into syntax problems when trying to construct a ‘Like’ based query on a string field.  Searched for a while until I found this:

http://social.msdn.microsoft.com/forums/en-US/linqprojectgeneral/thread/ec89724c-a9f3-47e7-9743-989a0f459718/

Which solved my problems … and L2E still continues to impress on flexibility!

Refreshing view on “Bad agile”

http://steve-yegge.blogspot.com/2006/09/good-agile-bad-agile_27.html

If you have a few minutes to spare, reading this good-agile-bad-agile article offers loads of fun and is a mental reset on agile if you inhale every word.

Agile software process tools review

Going through my annual review of the software development process tools on the market.  As the world moves to agile I am stunned by the lack of comprehensive tools available.  Maybe everybody is waiting for Microsoft to catch up and don’t dare enter this niche … ?   This is a more of a checklist for me than anything else ….. anyways the four tools on my list this year are:

 VersionOne (versionone.com): I have been a big fan of VersionOne for quite a while now.  It continues to provides excellent functionality but IMHO it hasn’t taken the big leap forward I have been expecting for the last 4 years.  Still the best tool for iteration planning and tracking on the market

Rally (rallydev.com): Impressive stuff. I will test this one next time I have the chance to test a product management tool in a real project

TargetProcess (targetprocess.com): No experience with this one but in its simplicity it looks like a university project (KISS), even thought the functionality seems to be comparable to VersionOne.  After browsing through the demo for a while it seems to have a better test functionality than VersionOne.

Scrum for Team Foundation Server (conchango.com): MS has been miles away in providing agile process managemenet capabilities by default with the team foundation server.  The scrum plugin is (surpisingly) the only option pushed as an option for extendin the basci TFS functionality.  Looking to install that today and test.

Are you doing a good job? :)

Most people think that they do pretty good work (even if they don’t). It’s just a little trick our minds play on us to keep life bearable. (joelonsoftware.com)

Software project management basics

Found a great article by Esther Derby while browsing through SCRUM user groups.  (http://www.stsc.hill.af.mil/CrossTalk/2006/11/0611Derby.html)  The very bare basics of being a software development manager.  Articles of excellence which I have seen too many examples of being absent from people struggling to control software development departments and organization.

• Decide What To Do and What Not To Do :: Great managers do not just accomplish work, they accomplish the right work.
• Limit Multitasking :: People lose time as they put away Task A and remember where they were on Task B. It takes time to retrieve and review documents or notes related to the task and to re-create a train of thought
• Keep People Informed :: People work best when they have the information they need. Great managers share what they know about the task and how the task fits into the goal of the project or organization.
• Provide Feedback :: People need to know how they are doing at work. Do not assume that people know when they are missing the mark or what they are doing well. Great managers meet one-on-one with people regularly, every week or every other week
• Develop People :: Great managers know the career and professional aspirations of the people they work with, and they strive to help them meet those goals when they can and help people move on when they cannot.

Af slyddu og fótbolta … taka 2

Gekk fram á mitt eigið blogg á inetnetinu, síðan síðla árs 2004.  Með hverri línu og hverri grein sem ég las, mundi ég af hverju ég byrjaði að taka þátt í þessu egótrippi 21. aldarinnar.  Ég áttaði mig eiginlega á að ómerkilegheit núsins eru gullkista minninga þegar í framtíð maður nær að lauma sér inn um leyndar dyr hversdags sem einu sinni var.  Skrítið að tveimur árum eftir október-slyddu-blogg eftir erfiðan fótboltatíma, bý ég í öðru húsnæði, er í annarri vinnu, er með allt önnur markmið og er nýbúinn að svæfa ársgamla dóttur mína ….  Ekkert sem ég sá í framtíðinni fyrir nákvæmlega 2 árum.  Það er þá kannski ágætt að skrifa bara aftur um ískalda október slydduna og erfiðan fyrirtækjafótbolta í kvöld … það verður líklega gaman að rifja þetta, að því er virðist, tilgangslausa blogg upp eftir nákvæmlega 2 ár

How to scare a telemarketer :) … rasandi snilld

http://joshualowry.vox.com/library/audio/6a00c225203796f21900c2252ab8c18e1d.html

Fyndin fótboltasaga

Ein sú allra besta fótboltasaga sem ég hef lesið:  http://fotbolti.net/fullStory.php?id=40597