Loading

How to display Foreign kay data in asp.net core with SP

nurs mamytov

How to display Foreign kay data in asp.net core with Stired Procedure if you have connected tables

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar6y ago
Hi,

Please use join and get relational data from tables and use this link to call store procedure in .net Core,
https://www.c-sharpcorner.com/article/asp-net-core-entity-framework-call-store-procedure/
Abhishek Mishra6y ago
To display data for connected table you can use join.
Let's say you have below two table

Table 1 : Employee
Id - Primary Key
Name
City
Table 2 : EmployeeAttendance
EmpId - ForeignKey Refrence from Employee
LoginDateTime -
LogoutDateTime

To display data you can use the below query
SELECT
     emp.Id
    ,emp.Name
    ,emp.City
    ,eat.LoginDateTime
    ,eat.LogoutDateTime
FROM
     Employee emp
     JOIN EmployeeAttendance eat ON emp.Id = eat.EmpId
Hope This helps.