Best Practices

-
This article is a bit dated but I believe it is still applicable:

Best Practices from MSDN

Comments

Post a Comment

Popular posts from this blog

Return View of a model or an HttpStatusCode

-
        public ActionResult Details(int? id)         {             if (id == null)             {                 return new HttpStatusCodeResult(HttpStatusCode.BadRequest);             }                     OrderNote orderNote = mymethodtoretriverecord(id);             if (orderNote == null)             {                 return HttpNotFound();             }             return View(orderNote);         }        
Read more

Meta Data - Annotating Models

-
One of the issues with using Entity Framework is that you may want some special annotation but you don't want to use a DTO or other object outside of EF. One way to afford you the opportunity to Annotate on the original EF model is to extend with a partial class of meta data. In your Data Models folder (or really anywhere in your data project) you would add a class (Partial Classes) that would contain empty pointers to your data classes - (in my tt files I have a company class and a systemUser class which represent models from the tables in my database): PartialClasses.cs using System.ComponentModel.DataAnnotations; namespace MySite.Data {     [MetadataType(typeof(systemUsersMetadata))]     public partial class systemUser     {     }     [MetadataType(typeof(companyMetadata))]     public partial class company     {     } } Once you have this setup you can begin to annotate! Create a system...
Read more

LINQ - Left join with where conditions

-
Left joins don't come natural to LINQ but the solution is not that complicated. Below is my example I needed to pass in 3 fields for my where clause and I was getting back the LoginName field from the USERS table - unfortunately sometimes this field was empty and my join would not work - in the SQL we know and love this is easily accomplished with a left join (take all the fields from the first table or the table on the left and any that match in the second table) Below you can see how this works. The 'subgroup' referenced below is just an alias, there is no table named subroup - almost acting like a temptable.  var mygroupitems = (from e in MyEntities.Terr_History                             join p in MyEntities.Users on e.Approver_User_Id  equals p.Users_Id into XX                             from subgroup in XX.DefaultIf...
Read more