Databases
StackOverflow2013
Postsdbo
POASP.NET MVC - Service Layer - Business Layer - Data Layer (EF) - SQL DB :: Data Transfer?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POASP.NET MVC - Service Layer - Business Layer - Data Layer (EF) - SQL DB :: Data Transfer?
    primarykey
    data
    text
    <p>I am planning to create 3 tier application using ASP.NET MVC as UI tier, WCF as Business tier and SQL DB as the database.</p> <p>My Business tier would split as Service Layer (WCF), Business Layer (Business logic, Business Model), Data Layer (Entity Framework - DB first).</p> <ul> <li><p>Data layer would implement the repository methods like Get, GetById, Update, Insert using the Entity Frameworks's Entities.</p></li> <li><p>Business layer consists of Business rules and its Models. (this is in POCO).</p></li> <li><p>The service layer would just expose the business functionality as possible service methods.</p></li> <li><p>The "M" in the MVC would just be the presentation model - used either by the Controller to get it converted to JSON / XML and give it to the View or to be consumed by the View directly.</p></li> </ul> <p>Although the above mentioned approach is common I would still like to get it confirmed if this is a good design ?</p> <p>My real question is about the data transfer between the layers ( UI (MVC) - Service (WCF) - Business - Data layer)</p> <p>Lets say I have a GET operation initiated to retrieve Account and its Traits from database. In database its represented as two different tables.</p> <ul> <li>Accounts --> AccountNumber, Name, Type</li> <li>AccountTraits --> Id, AccountNumber, Category, etc..</li> </ul> <p>Within Datalayer I want to write a method to get these two tables records for a given<br> AccountNumber using EF.</p> <p>My Business Model has a two classes called Account and AccountTraits. The AccountTraits's object collection is aggregated into Account class. </p> <p>like,</p> <pre><code>public class Account { string AccountNumber; List&lt;AccountTraits&gt; Traits; } </code></pre> <p>Now, If I want to populate these Domain objects with its data I can use the EF query something like the below in my data layer.</p> <pre><code>public IEnumerable&lt;Account&gt; GetAccountAndItsTraits(string AccountNumber) { var query = from a in db.Accounts select new Accounts() { AccountName = a.AccountName, Traits = from t in a.AccountTraits .... return query; } </code></pre> <ol> <li><p>Is this the rite approach to populate the Business model POCO from Data layer (EF) ?</p></li> <li><p>Now, after applying some business logic I would like to return these collection to the UI. How do I transfer these to the Service layer and how do I give it to the UI Model ?</p></li> <li><p>Should I have to define DataContract in WCF with exact class definition as Business model and then <strong>"copy the data"</strong> to it and give it to the UI ? Then the UI should get the data from the WCF proxy objects and <strong>"copy to its Presentation Model"</strong> (which is again should have its own Accounts and AccountTraits - may be with some extra fields)?</p></li> </ol> <p>It would be great if you can throw some lights on these topics.</p> <p>Thanks!</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmarc_s
    1. USKarthik
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POASP.NET MVC - Service Layer - Business Layer - Data Layer (EF) - SQL DB :: Data Transfer?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POASP.NET MVC - Service Layer - Business Layer - Data Layer (EF) - SQL DB :: Data Transfer?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POASP.NET MVC - Service Layer - Business Layer - Data Layer (EF) - SQL DB :: Data Transfer?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThis seems complex for a new application.
      singulars
      1. POASP.NET MVC - Service Layer - Business Layer - Data Layer (EF) - SQL DB :: Data Transfer?
      1. USChuck Conway
    2. COThis is a good approach. I am also running in to same question. In my research on it, I found, we can use datacontract between presentation layer and wcf. It seems you are right what you are doing in Datalayer for extracting db result.
      singulars
      1. POASP.NET MVC - Service Layer - Business Layer - Data Layer (EF) - SQL DB :: Data Transfer?
      1. USBlueBird
 

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.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload