⚠️ This page has been archived

✅ New page with updated info: bettersoftwaresuggestions.com

Home > Archive > SSW Standards > Better Software Suggestions > SSW Microsoft .NET LINQ Suggestions

Do you agree with them all? Are we missing some? Let us know what you think.

  1. Please add a checkbox to hide stored procedures

    The checkbox below does a good job of hiding noise, but it doesn't complete the job, it had better add another checkbox to hide stored procedures, this would hide CustOrderHistResult, CustOrdersDetailResult etc.

    Checkbox to hide stored procedures.
    Figure: Add a checkbox to hide stored procedures
  2. Please add a default namespace to entity

    I like how with a DBML I don't have to specify a namespace

    But with EDMX I do, If you allowed me to have Null, it would nicely default to the folder name eg. in this case Northwind.Data.SQL

  3. LINQ to Entities Connection String is in the old style

    When you create a edmx - it should create a connection string in the new style... aka in the Properties:

    Connection String should create in the new style.
    Figure: Connection string should create in the new style.
  4. Allow the EDMX to have no namespace specified

    LINQ to SQL allows the DBML file to have no namespace specified and LINQ to Entities should be consistent. It should automatically pick up the namespace based on its location.

    Allow namespace null
    Figure: Allow namespace to be nullable.
  5. Function icon should use the standard icon in VS

    These icons should be more distinctive. At a glance they look the same and aren't very indicative of their purpose.

    Wrong Icon
    Figure: The function icon is same as the table's

    The function mapping icon should use the standard icon for a function:

    Standard Icon
    Figure: The standard icon in VS
  6. DataContext and Entities should be split up

    LINQ to SQL is a 2 tiered technology out of the box. To allow it to be used in n tiered architecture the DataContext (data access logic) needs to be separated from the Entities.

    I want to be able to generate the DataContext separately to the Entities

    e.g.

    SqlMetal /database:Northwind /dataContext:NorthwindDataContext.cs /entities:NorthwindEntities.cs
    Figure: DataContext and Entities should be split up

Acknowledgments

Adam Cogan
Lei Xu