locked
LinqToSql RRS feed

  • Question

  • Hello,

    I would like to know what is your idea of a N-layer application using LinqToSql. I used to work in the following way:

    UI

    BLL

    DAL

    Entities

    In this model, is it best to create the model inside the Entities Project ou directly inside the DAL?

    Thanks in advance.

     

    Tuesday, October 27, 2009 6:04 PM

Answers

  • Greetings,

    Case 1 : Without BLL(BUSINESS LOGIC LAYER).
    Generic Flow

                      UI <==> ADO.NET Entity Framework(DAL) <==> Database (SqlServer 2005 or SqlServer 2008).

    Case 2: With BLL(BUSINESS LOGIC LAYER).
    Generic Flow

      UI <==> BLL <==> ADO.NET Entity Framework(DAL) <=> Database (SqlServer 2005 or SqlServer 2008).

    Note this Point:
    • Here we are using BLL because in the application architecture requires communication with Bitztalk sever or any other business components. It will depends application software architecture.
    Some links are given below


    Entity Framework Terminology
    • http://msdn.microsoft.com/en-us/library/bb387161.aspx

    Introducing the Entity Framework
    • http://msdn.microsoft.com/en-us/library/bb399567.aspx

    ADO.NET Entity Framework
    • http://msdn.microsoft.com/en-us/library/bb399572.aspx

    Quickstart (Entity Framework)
    http://msdn.microsoft.com/en-us/library/bb399182.aspx

    Application Scenarios (Entity Framework)
    • http://msdn.microsoft.com/en-us/library/bb738689.aspx

    Entity Framework Features
    • http://msdn.microsoft.com/en-us/library/bb896338.aspx

    Entity Framework Terminology
    • http://msdn.microsoft.com/en-us/library/bb387161.aspx

    Entity Framework Resources
    • http://msdn.microsoft.com/en-us/library/bb738448.aspx

    Hope this helps you out.

    Take Care

    PL


    Helping People To Solve Technical Problems
    Wednesday, October 28, 2009 6:09 PM
  • I am currently writing an article series over on DotNetSlackers.com where I discuss the various forms of what people think is an nTier application vs. what actually is an nTier.  Take a look at the Three Tiers for MVC series here:

    http://dotnetslackers.com/projects/StackOverflowInspiredKnowledgeExchange/

    Andrew Siemer www.andrewsiemer.com blog.andrewsiemer.com www.socialnetworkingin.net
    Wednesday, October 28, 2009 10:27 PM

All replies

  • Greetings,

    Case 1 : Without BLL(BUSINESS LOGIC LAYER).
    Generic Flow

                      UI <==> ADO.NET Entity Framework(DAL) <==> Database (SqlServer 2005 or SqlServer 2008).

    Case 2: With BLL(BUSINESS LOGIC LAYER).
    Generic Flow

      UI <==> BLL <==> ADO.NET Entity Framework(DAL) <=> Database (SqlServer 2005 or SqlServer 2008).

    Note this Point:
    • Here we are using BLL because in the application architecture requires communication with Bitztalk sever or any other business components. It will depends application software architecture.
    Some links are given below


    Entity Framework Terminology
    • http://msdn.microsoft.com/en-us/library/bb387161.aspx

    Introducing the Entity Framework
    • http://msdn.microsoft.com/en-us/library/bb399567.aspx

    ADO.NET Entity Framework
    • http://msdn.microsoft.com/en-us/library/bb399572.aspx

    Quickstart (Entity Framework)
    http://msdn.microsoft.com/en-us/library/bb399182.aspx

    Application Scenarios (Entity Framework)
    • http://msdn.microsoft.com/en-us/library/bb738689.aspx

    Entity Framework Features
    • http://msdn.microsoft.com/en-us/library/bb896338.aspx

    Entity Framework Terminology
    • http://msdn.microsoft.com/en-us/library/bb387161.aspx

    Entity Framework Resources
    • http://msdn.microsoft.com/en-us/library/bb738448.aspx

    Hope this helps you out.

    Take Care

    PL


    Helping People To Solve Technical Problems
    Wednesday, October 28, 2009 6:09 PM
  • I am currently writing an article series over on DotNetSlackers.com where I discuss the various forms of what people think is an nTier application vs. what actually is an nTier.  Take a look at the Three Tiers for MVC series here:

    http://dotnetslackers.com/projects/StackOverflowInspiredKnowledgeExchange/

    Andrew Siemer www.andrewsiemer.com blog.andrewsiemer.com www.socialnetworkingin.net
    Wednesday, October 28, 2009 10:27 PM