current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 4 down vote favorite

I use mvc/razor with database first model entity framework.. What is the difference between creating a Model inside the project and having table.

Example: I have peopleModel.cs inside Models/peopleModel.cs I Have a table in edmx file ,called tblpeople with same fields. What is the difference between them?

share|improve this question

3 Answers 3

up vote 2 down vote accepted

Your tblpeople is an image of your database.
Your peopleModel is an image of your table, you can see it as an extension. For example here you can add more properties you don't have in your database (in other partial classes).

EDIT:

For example we have a Database-First application with the following db-based class:

public partial class Product
{
    public byte Type { get; set; }
    public string Language { get; set; }
}

BUT we need to have some more fields for displaying additional infos. So we created another partial class (in a seperate file):

public partial class Product
{
    public Terminology Terminology { get; set; }
}

So you can update your tablemodel from the database and have your extension seperated from the autoupdated edmx file.

share|improve this answer
    
Thankyou for replying @obl Tobl. That is my question.What can be possible difference between the fields inside tblpeople and peopleModel. –  gs11111 Jun 14 '13 at 12:33
1  
Like i already wrote, you can have your tables in the background and additional properties in your model. For example properties you need for calulations or other things, but you don't have to store in database. –  Obl Tobl Jun 14 '13 at 12:37
    
So is that possible to store the newly created field in peopleModel.cs in database? –  gs11111 Jun 14 '13 at 13:17
1  
if you want to store in database, just alter your table and update your edmx file (hope i understand you the right way...). After altering and updating your table, the field is in your model automatically. –  Obl Tobl Jun 14 '13 at 13:19
    
According to my understanding,model/peopleModel.cs is used for adding new fields to use in program that may not be added in edmx file(Database table). Am I getting it right? –  gs11111 Jun 14 '13 at 13:24
up vote 1 down vote

If you want to use more than one table's attribute in a single view,

you just need to create a model havin properties which you want from tables and just bind that model to view, you'll get the result.

I Think With the table, this thing is not possible. because you can have a view inherited from only one object

share|improve this answer
up vote 1 down vote

This confusion is attributable to ASP.NET MVC's blogs, samples, documentation and project templates.

The M stands for Model, which actually is a ViewModel, but the templates assume your ViewModel is the same as your database Model, which hardly ever is the case.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.