Get request using Entity Framework

24 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$49.99
List Price:  $69.99
You save:  $20
€46.42
List Price:  €64.99
You save:  €18.57
£39.83
List Price:  £55.77
You save:  £15.93
CA$68.34
List Price:  CA$95.68
You save:  CA$27.34
A$75.68
List Price:  A$105.96
You save:  A$30.28
S$67.48
List Price:  S$94.48
You save:  S$27
HK$390.53
List Price:  HK$546.78
You save:  HK$156.24
CHF 45.23
List Price:  CHF 63.33
You save:  CHF 18.09
NOK kr543.62
List Price:  NOK kr761.11
You save:  NOK kr217.49
DKK kr346.42
List Price:  DKK kr485.02
You save:  DKK kr138.59
NZ$83.17
List Price:  NZ$116.44
You save:  NZ$33.27
د.إ183.60
List Price:  د.إ257.06
You save:  د.إ73.45
৳5,471.12
List Price:  ৳7,660.01
You save:  ৳2,188.88
₹4,168.17
List Price:  ₹5,835.78
You save:  ₹1,667.60
RM236.95
List Price:  RM331.75
You save:  RM94.80
₦61,737.65
List Price:  ₦86,437.65
You save:  ₦24,700
₨13,922.21
List Price:  ₨19,492.21
You save:  ₨5,570
฿1,837.56
List Price:  ฿2,572.74
You save:  ฿735.17
₺1,617.36
List Price:  ₺2,264.43
You save:  ₺647.07
B$253.57
List Price:  B$355.02
You save:  B$101.45
R925.26
List Price:  R1,295.44
You save:  R370.18
Лв90.75
List Price:  Лв127.05
You save:  Лв36.30
₩67,788.68
List Price:  ₩94,909.58
You save:  ₩27,120.90
₪185.81
List Price:  ₪260.15
You save:  ₪74.34
₱2,852.60
List Price:  ₱3,993.87
You save:  ₱1,141.27
¥7,651.71
List Price:  ¥10,713.01
You save:  ¥3,061.30
MX$848.33
List Price:  MX$1,187.73
You save:  MX$339.40
QR182.01
List Price:  QR254.83
You save:  QR72.82
P679.12
List Price:  P950.82
You save:  P271.70
KSh6,605.16
List Price:  KSh9,247.76
You save:  KSh2,642.59
E£2,394.23
List Price:  E£3,352.12
You save:  E£957.88
ብር2,861.57
List Price:  ብር4,006.43
You save:  ብር1,144.85
Kz41,791.64
List Price:  Kz58,511.64
You save:  Kz16,720
CLP$47,104.79
List Price:  CLP$65,950.47
You save:  CLP$18,845.68
CN¥361.79
List Price:  CN¥506.53
You save:  CN¥144.74
RD$2,896.80
List Price:  RD$4,055.76
You save:  RD$1,158.95
DA6,728.30
List Price:  DA9,420.16
You save:  DA2,691.86
FJ$112.64
List Price:  FJ$157.70
You save:  FJ$45.06
Q387.49
List Price:  Q542.52
You save:  Q155.02
GY$10,429.06
List Price:  GY$14,601.52
You save:  GY$4,172.46
ISK kr6,980.60
List Price:  ISK kr9,773.40
You save:  ISK kr2,792.80
DH502.81
List Price:  DH703.98
You save:  DH201.16
L883.05
List Price:  L1,236.34
You save:  L353.29
ден2,855.74
List Price:  ден3,998.26
You save:  ден1,142.52
MOP$401.24
List Price:  MOP$561.77
You save:  MOP$160.53
N$922.79
List Price:  N$1,291.99
You save:  N$369.19
C$1,835.15
List Price:  C$2,569.36
You save:  C$734.20
रु6,656.11
List Price:  रु9,319.09
You save:  रु2,662.97
S/186.09
List Price:  S/260.54
You save:  S/74.45
K192.70
List Price:  K269.79
You save:  K77.09
SAR187.48
List Price:  SAR262.50
You save:  SAR75.01
ZK1,344.69
List Price:  ZK1,882.68
You save:  ZK537.98
L230.99
List Price:  L323.40
You save:  L92.41
Kč1,163.34
List Price:  Kč1,628.77
You save:  Kč465.43
Ft18,094.88
List Price:  Ft25,334.28
You save:  Ft7,239.40
SEK kr539.27
List Price:  SEK kr755.02
You save:  SEK kr215.75
ARS$43,903.33
List Price:  ARS$61,468.17
You save:  ARS$17,564.84
Bs345.22
List Price:  Bs483.33
You save:  Bs138.11
COP$194,164.52
List Price:  COP$271,845.87
You save:  COP$77,681.34
₡25,478.72
List Price:  ₡35,672.25
You save:  ₡10,193.53
L1,231.47
List Price:  L1,724.16
You save:  L492.69
₲373,200.63
List Price:  ₲522,510.75
You save:  ₲149,310.11
$U1,910.59
List Price:  $U2,674.97
You save:  $U764.38
zł200.97
List Price:  zł281.37
You save:  zł80.40
Already have an account? Log In

Transcript

Welcome to the next level. In previous slides, we have created our student repository class by using our interface, our student repository okay and this is our class. And also we have added the methods which we request and try to code for. Now, we have to write one controller, which uses Entity Framework for accessing the data and posting data. Right now, if you see here, our tables are created. And if I use view code So, I want to use new data.

Now, if you see there is no data there is no data sample to run, okay. So for primary purpose for getting the data and checking our Entity Framework work or not, so for that reason, I insert two or three records manually. Okay. So how are you? It's Sunday okay. Now this is student information.

So, I knew one group is going to run this okay and he goes you created the identity column which is auto created. So even if I remove these and if I run this Okay, now, the data is inserted and it is not seen here You can see the data is now saying I want to insert data subject table part of the reason I use some right insert statement is to in these No, no there it is. Okay. So, now, some primary data for getting some data, we inserted some records men now we have to add one controller which uses Entity Framework for getting the data Okay. Now I want one controller one controller Entity Data in this class is inherit from our controller class. Now you can remember our inversion of control and dependency injection lab.

We pass the interface okay in constructor That's the interface. Bye you using constructor injection once when I say these declare of This is UT student now because we did it nicotine collection Use NTT DATA starting up now you've gone over EPA Please let me see what you can see here. good reason. Now, we have not written the code for that subject collection, how to return that. So that's why it is coming here and empty array. But we will create, or we write the code for that.

Right now, our API is working and our Entity Framework works. Now here, I will create another beat, get student ID and return that student. You did pass one parameter which is yeah I'm here. You if I love this problem What is the reason I use postman and I pass this one up. Now you can see you can see them right now, it is not giving out some collection. We will try to call that Oh, it's working on means we are getting all students please.

Single student also. Now we have to write the code for some connection Yeah, I'm modify some is equal to He's the reason is none or not is not not fun. And if we find these and then what we should do one for each look for that In our region here, we do add one winner. We are written in the lease. Okay? We use these what our use this reason students know the seats empty.

The reason we added is new entities I see four marks is equal to one and right now, we do these are what actually we are getting Some empty student empty subject collection for that no problem. See, what is the reason sorry we change here know and I use a post calling this region again we are using empty collection Okay. Now we have to add that empty collection in in the indication. So what when these students indeed these students now have gone when subjects use me I know Here I will assign you but you're in basically in the middle out into these into these okay no use. So, how to handle this and then this we one by one Subject collection object in how I will show students is not then I use one for each. Oh now, what subjects here I will end by my kids We'll see what will happen on this again.

Okay, now you can see our collection is filled. No, but it shows wrong. Okay, but surely somebody didn't see Okay, student ID two marks and for seeking the using the bank three three reason why we do work on position for that reason. So now you can do this what is the reason Find out know what to know this was the cookie, chick. No you now, here we'll take step by step. We are getting three records from the Smith.

No, well, these meta, meta once and you can see here, we're not adding condition of student ID so that's why it returns all the subjects isn't in the table. Now, we have a condition where see it is equal equal. Okay? Now, again why this issue is I need to build this again or you start running this. Okay? Now well first of all follow up to this.

It's working okay. Here to go here. No no yeah this okay. Now there is a cookie you can see the result is okay. Thing is there. In this we miss to add the condition here.

So that's why it's giving out all the subjects present in that table for all students. Now that's all about good records. In the next lecture we will see the post request. Thank you for watching. We will meet next time

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.