creating model class where IDs from multiple model class are required

arsar 121

I have a model class for Company Demographic Info

namespace myApp.Core.Models
{
public class FirmDemoGraphicInfoModels
{
[Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int FirmId { get; set; }
public string FirmName { get; set; }
public string FirmNumber { get; set; }
public string Address { get; set; }
}
}

another model class to for storing the services provided by different firms

namespace myApp.Core.Models
{
public class ServiceModels
{
[Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int ServiceId { get; set; }
public string ServiceName { get; set; }
}
}

I have to create a table which can store the information of Company along with its service. One company will be registered for only one service. And the company will get serial registered id [FirmRegistrationNumber] generated from the system.
Attributes for the new table:
[FirmId],[ServiceId], [FirmRegistrationNumber]

How to create model class for this?

Also can I generate view page via entity framework such that to enter Firm Demographic Information and there should be dropdown for selecting Services in a single view page. Is it possible?

Yijing Sun-MSFT 7,081 Reputation points

2021-07-28T05:11:56.127+00:00

Hi @arsar ,
Could you tell us what's type of your project? ASP.NET Core? Do you use the EF Core?
Best regards,
Yijing Sun
arsar 121 Reputation points

2021-07-28T10:30:34.223+00:00

I It is ASP.NET MVC.

<system.web>
<authentication mode="None" />
<compilation debug="true" targetFramework="4.7.2" />
<httpRuntime targetFramework="4.7.2" />
</system.web>

<section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
Yijing Sun-MSFT 7,081 Reputation points

2021-07-29T08:04:55.063+00:00
Hi @arsar ,
Now that you have two model classes, you need to create a relationship between the two. In a SQL database this is achieved by Foreign Keys. In Entity Framework, you can achieve the same by using Navigational Properties.You could do in the services models:

Public class ServiceModels { public int ServiceId{get;set;} public string ServiceName{get;set;} public int FirmId{get;set;} [ForeignKey("FirmId")] public virtual FirmDemographicInfoModels FirmDemographicInfoModels {get;set;} }

Finally to be able to use your new Data model class with Entity Framework, you need to add another property to your DbContext class so that you have a means of accessing your data:

public class DefaultConnection:DbContext { public DbSet<FirmDemographicInfoModels> FirmDemographicInfoModels { get; set; } public DbSet<ServiceModels> ServiceModels{ get; set; } }

Best regards,
Yijing Sun

Share via

creating model class where IDs from multiple model class are required

Your answer