Databases
StackOverflow2013
Postsdbo
POArchitecture of MVC application without using entity framework
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POArchitecture of MVC application without using entity framework
    primarykey
    data
    text
    <p>I am new in MVC application development.I am willing to develop a new project using MVC, i looked a lot for architectures that suits to MVC application. After reading many articles and blogs i came to know that repository pattern can be used for this.<br/> Based on my understanding before starting real project i created a dummy project structure like described below [ Not using EDMX file, entity framework in project, defined custom DAL ]</p> <p>Name of my dummy application is Repository.I took Country,state and city relationship as example to develop dummy application :</p> <p><strong>Repository_DAL_V1</strong> <em>class library</em> This library has class as below :<br/> SQLHelper.cs : This class have methods to get executed for queries like ExecutenonQuery etc.<br/></p> <p><strong>Repository_DTO_V1</strong> <em>class library</em> This library has class as below :<br/> CountryDTO.cs : This class is inherited from CountryModel.cs as [ CountryDTO:CountryModel ].This will be used to move data between all layers of application.If there is any property that is supposed to be used in business then this will be created in DTO not in model.<br/> CountryDTOMapper.cs : This is used to map data from database in form of DataTable into collection of DTO object.<br/></p> <p><strong>Repository_Implementation</strong> <em>web mvc project</em> This is UI Layer.<br/></p> <p><strong>Repository_IRepositories_V1</strong> <em>class library</em> This library has class as below :<br/> ICountryRepository.cs : This is a interface having declared functions like SaveCountry() etc.<br/></p> <p><strong>Repository_Models</strong> <em>class library</em> This library has class as below :<br/> CountryModel.cs : This class has properties exactly for all columns of table in database.</p> <p><strong>Repository_Repositories_V1</strong> <em>class library</em> This library has class as below :<br/> CountryRepository.cs : This is a repository class having defined functions like SaveCountry() etc.<br/></p> <p><strong>Repository_ViewModel_V1</strong> <em>class library</em> This library has class as below :<br/> CountryViewModel.cs : This will be build for Country View on screen.</p> <p>above projects reference details :</p> <p>Repository_DTO_V1 has reference of Repository_Models.<br/> Repository_IRepositories_V1 has reference of Repository_DTO_V1,Repository_Models.<br/> Repository_Repositories_V1 has reference of Repository_IRepositories_V1,Repository_DAL_V1,Repository_DTO_V1,Repository_Models.<br/> Repository_ViewModel_V1 has reference of Repository_Repositories_V1,Repository_IRepositories_V1,Repository_DTO_V1,Repository_Models.<br/></p> <p>I need guidence from all of you to steer me in the right direction.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USGaurav Rajput
    1. USGaurav Rajput
    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
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POArchitecture of MVC application without using entity framework
      1. USYang
      1. VTFavorite
    1. This table or related slice is empty.
 

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