How to join between two class model Server Type Server Name to get Server Type as Display?

Question

I work on blazor with .net core 7 . I face issue I can't displaying Server Type Instead of Server Type Id when display all servers Name .

so How to change my GetAll() Function to get Server Type instead of Server Type Id .

With another meaning I need to display Server Id and Server Name from Server Names class with Server Type from Server Type class.

because not good to display Server Type Id for customer or user use application

so I need to use Server Type from Server Type model with ServerId and ServerNames by Joining ServerTypeId from ServerNames Class and ServerType  Class .

on service

public interface IserverNamesService : IRepository<ServerNames>
    {
    }
on controller ServerNames :

private readonly IserverNamesService _IserverNamesService;
        public  ServerNamesController(IserverNamesService IserverName)
        {
        _IserverNamesService = IserverName;
        }
        [HttpGet]
        public IActionResult GetAll()
        {
            return Ok(_IserverNamesService.GetAll());
          
        }
ServerNames Model as below :

public class ServerNames
    {
        [Key]
        public int ServerID { get; set; }
        public string ServerName{ get; set; }
        public int ServerTypeId { get; set; }

    }
Server Type Model as below :

   public class ServerTypes
    {
        [Key]
        public int ServerTypeId  { get; set;}
        public string ServerType { get; set;}
    }
repository used as below :

public interface IRepository<TEntity> where TEntity : class
{
    IEnumerable<TEntity> GetAll();
   
}
public class BaseRepository<TEntity> : IRepository<TEntity> where TEntity : class
{
    internal AppsRepositoryDBContext _context;
    internal DbSet<TEntity> dbSet;

    public BaseRepository(AppsRepositoryDBContext context)
    {
        _context = context;
        this.dbSet = _context.Set<TEntity>();
    }
public IEnumerable<TEntity> GetAll() => _context.Set<TEntity>().ToList();
}
on blazor component ServerNames.razor

<table class="class table-striped">
    <thead>
        <tr>
            <th>Server Id</th>
            <th>Server Name</th>
            <th>Server Type</th>

        </tr>
    </thead>
    <tbody>
        @foreach (var serv in ServerName)
        {
        <tr>
            <td>@serv.serverID</td>
            <td>@serv.serverName</td>
            <td>@serv.serverType</td>
            

        </tr>
        }
    </tbody>

</table>

@code
{
public class ServerNamesClass
    {
        public int serverID { get; set; }
        public string serverName { get; set; }
        public string serverType { get; set; }
    }
    public class ServerTypesClass
    {
        public int serverTypeId { get; set; }
        public string serverType { get; set; }
    }
    private IEnumerable<ServerNamesClass> ServerName = Array.Empty<ServerNamesClass>();
Expected Result as below :

SeverID  ServerName ServerType

Answer 1

First, it helps if you follow standard framework patterns. Designing related entity models is covered in the following reference documentation.

Relationships

EF Core allows three different patterns for loading related data. Loading data covered in the official documentation.

Loading Related Data

Unfortunately, you did not show the implementation. Maybe you expect lazy loading which is not turned on by default in EF Core. See the previous link.

Answer 2

can you clear please by code

Answer 3

Hi @Ahmed Salah Abed Elaziz

Welcome to Asp.net core Q&A forum.

To your issue, you can add a navigation property in the ServerNames model and configure the ServerNames and ServerTypes with One-to-one relationship. After that when query the ServerNames, you can use the Include method to load the related ServerTypes model, after that, you can display the server type based on the navigation property. Code like below:

Add the navigation property in the ServerNames model:

    public class ServerNames
    {
        [Key]
        public int ServerID { get; set; }
        public string ServerName { get; set; }
        public int ServerTypeId { get; set; }
        [ForeignKey("ServerTypeId")]
        public virtual ServerTypes ServerTypes { get; set; }
    }

Then, in the ServerNamesServices GetAll method, query the database and use Include method to load the ServerNames with ServerTypes:

    public interface IserverNamesService : IRepository<ServerNames>
    { 
    }

    public class ServerNamesServices : IserverNamesService
    {
        private readonly TestDbContext _context;
        public ServerNamesServices(TestDbContext testDbContext) {
            _context = testDbContext;
        }

        public IEnumerable<ServerNames> GetAll()
        {
            return _context.ServerNames.Include(c=>c.ServerTypes).ToList();
        }   
    }

register the service in the program.cs file, like this:

builder.Services.AddScoped<IserverNamesService, ServerNamesServices>();

In the Blazor component: in the select statement, create the ServerNamesClass entity based on the query result:

@page "/serverpage"

<PageTitle>Server Name List</PageTitle>

@using BlazorServerApp.Data
@using BlazorServerApp.Services
@inject IserverNamesService servernameService 
 
@if (servernameclasses == null)
{
    <p><em>Loading...</em></p>
}
else
{
    <table class="table">
        <thead>
            <tr>
                <th>Server ID</th>
                <th>Server Name</th>
                <th>Server Type</th>
            </tr>
        </thead>
        <tbody>
            @foreach (var servername in servernameclasses)
            {
                <tr class="draggable"
            data-id="1001"
            id="row1"
            tabindex="1"> 
                    <td>@servername.serverID</td>
                    <td>@servername.serverName</td>
                    <td>@servername.serverType</td>
                </tr>
            }
        </tbody>
    </table>
}
 
@code {
    private List<ServerNamesClass> servernameclasses;

    protected override async Task OnInitializedAsync()
    {
        servernameclasses = servernameService.GetAll().Select(c =>
            new ServerNamesClass() { 
                serverID = c.ServerID, 
                serverName = c.ServerName, 
                serverType = c.ServerTypes.ServerType })
                .ToList();
    }
}

The database table:

the result as below:

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Best regards,

Dillion