CODEWITHSUNDEEP
asp.net-mvc-3
NoviceMe
NoviceMe

Reputation: 3256

How to make single controller for two database classes - MVC3

I have two database classes as defined below:

 public class TopDate
    {
        [Key]
        public int DateId { get; set; }
        public DateTime Date { get; set; }
    }
 public class TopSong
    {
        [Key]
        public int SongId { get; set; }        
        public string Title { get; set; }
        public int DateId { get; set; }
    }

where DateId is foreign key to TopSong

I am creating a controller through which i can create, delete or edit these database values.

When i right click on controller class and add controller i can only select one of the two classes defined above. Is there a way to make 1 controller to handle database updates to both these tables on one page?

Error Image: enter image description here

Upvotes: 0

Views: 337

Answers (2)

Display Name
Display Name

Reputation: 4732

The objects you showing (code) are database classes (so called domain objects). What you need to do is to define a view model, a standard ASP MVC practice: you define a class, that is tailored for specific view and only containing data relevant to that particular view. So you will have a view model for a view that will create a song, another that will update it etc.

Actually situation you describing is classical situation to use view models. Using domain objects in the views, however, is really really bad practice and prone to more problems than you want to deal with.

Hope this helps.

Upvotes: 0

Tommy
Tommy

Reputation: 39807

Your controller should not be dealing directly with domain objects (meaning those things that are directly associated with your database). Create a ViewModel that contains the properties that you need, use your service layer to populate the ViewModel and your controller will use that as the Model for its base. An example of your ViewModel could be something like the following given your description above:

public class MusicViewModel
{
    public int SongId {get;set;}
    public string Title {get;set;}
    public IEnumerable<DateTime> TopDates {get;set;}
}

This view model would contain a list of all dates that a specific song was a Top Song.

Upvotes: 1

Related Questions