Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful. I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you ua-cam.com/users/kudvenkatplaylists?view=1&sort=dd If you need DVDs or to download all the videos for offline viewing please visit www.pragimtech.com/order.aspx Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. ua-cam.com/video/y780MwhY70s/v-deo.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. ua-cam.com/users/kudvenkat If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them. Good Luck Venkat
Outstanding tutorial. I like the way you demonstrates each and every points with a simple examples it was quite excellent. I learnt a lot from you via these tutorials and fundamental things got cleared which I can't ask someone as they felt bit silly but more important to understands the complexity of large programs. Its good enough for all .net programmers. Thank you so much Venkat. I hope more and more guys should watch and learn the things via these tutorials. Happy programming! Cheers, Kamaraju
Anwar Mogal Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful. I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you ua-cam.com/users/kudvenkatplaylists?view=1&sort=dd Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. ua-cam.com/video/y780MwhY70s/v-deo.html If you want to receive email alerts, when new videos are uploaded, please feel free to subscribe to my youtube channel. ua-cam.com/users/kudvenkat If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please free to share the link with your friends and family who you think would also benefit from them.
Hello SS - Wow...that's great to know. Thank you very much for all the kind words. I have included all the C# tutorial videos in logical sequence on the following page. You will also find text version of the videos and slides. Hope you will find this page handy. Good luck and all the very best with everything you are doing. www.pragimtech.com/courses/c-sharp-tutorial-for-beginners/
so wonderful and amazing. I always learn from your channel if the required material is available here. If not then I search for others but first of all I come here. you are so amazing and your way of teaching is superb.
Can anyone help me understand the part with, employees = dept.Employees .. ? how did the reference of 'dept.' work ? I have seen it refer from the DbContext object in most cases.
Hi, I had the same doubt while watching this tutorial. But if we go to the tutorial portion where.edmx file is created we can clearly see that there is a relationship between department and employee entities which is shown with a connecting line. This line means that every department will have a list of employees. So that list of employees is actually created in the department class at the end as a list of property of type Employee.That's why in the loop he was able to refer Employee entity by using the dept object. I am sure this will clear your doubt.👍
Question about Var vs Type at (16:12). Is var a better option for declaring result because it's allows the logic and return value to be updated/changed, or would you in a professional setting have the type written and update it to new return type when adding the 2nd select statement?
In this tutorial you used ADO.NET entity Data Model, but in the beginning of your LINQ tutorials you used LINQ ti SQL classes. What is the difference, it seems they are doing the same thing to me?
Sir, you nailed it.... I have learned a lot from your informative videos.... BTW, it would be great if you upload videos about Gof design patterns... may God bless you
Great as always. Whenever you have time, would you mind making a video to sort an array of students and the marks scored which are in random order. Then displaying the results with highest score and corresponding name in some web form. I am planning to develop such a project for kids in Himalayas, Thanks in advance.
Mageshwaran K I believe IQuerable is quite good when querying the data from database as it executes the select query on server side with all filters but IEnumerable executes select query on server side, load data in-memory on client side and then filter data. Therefore IEnumerable prepares for Linq to XML or collection objects e.g. Array, Dictionary list etc. Another important point to remember is IQueryable interface inherits from IEnumerable, so whatever IEnumerable can do, IQueryable can also do.
Sir you did not explain how to use the second overload on "where" method which takes 2 parameters instead you went on explaining how select manages the 2 parameters
dept.Employess.Where(x=>x.Gender=="Male"); I don't get a thing in the above point. How does dept can refer to employees. dept can have Id, Name and Location details according to the tblDepartment table. But how can it shows the employees belong to a particular department. Kindly guide me.
+Praveen Kumar if you look at the script of creating Employee table on sql server.. it has a column DepartmentID (reference key) which refers to department table. So when Entity Data MOdel genarate the database, it creates a relationship between the 2 table (on the sample, its zero or one to many relationship) because of that reference key. and it generate the navigation property. the dept.Employees is a navigation property refering to Employee table.
coop78751 Department and Employee are Model classes automatically generated based on the selected tables and these are listed down in the .edmx file. Watch video snap at 18:46.
Visual studio is smart enough to rename the entities to make their name meaningful. We have multiple department n employee in db table Department & Employee. That's why VS named Entities as Departments & Employees. This is as per my understanding while watching EF tutorials from this channel.
Hi Venkat! You're the best teacher I have never had !
Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful.
I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you
ua-cam.com/users/kudvenkatplaylists?view=1&sort=dd
If you need DVDs or to download all the videos for offline viewing please visit
www.pragimtech.com/order.aspx
Slides and Text Version of the videos can be found on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use my youtube channel.
ua-cam.com/video/y780MwhY70s/v-deo.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
ua-cam.com/users/kudvenkat
If you like these videos, please click on the THUMBS UP button below the video.
May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them.
Good Luck
Venkat
You deserve it!
I agree bro, but correct syntax is " have EVER had" :D not never i think
Hi, Venkat, I dont know always, how to thank you.... But you are helping me a lot,
Best Teacher in my Career...
Greeting from German
Outstanding tutorial. I like the way you demonstrates each and every points with a simple examples it was quite excellent.
I learnt a lot from you via these tutorials and fundamental things got cleared which I can't ask someone as they felt bit silly but more important to understands the complexity of large programs.
Its good enough for all .net programmers. Thank you so much Venkat. I hope more and more guys should watch and learn the things via these tutorials.
Happy programming!
Cheers,
Kamaraju
Great tutorial Venkat, they way you explain the stuff goes behind the scenes is simply superb, please keep it coming.
Anwar Mogal Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful.
I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you
ua-cam.com/users/kudvenkatplaylists?view=1&sort=dd
Slides and Text Version of the videos can be found on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use my youtube channel.
ua-cam.com/video/y780MwhY70s/v-deo.html
If you want to receive email alerts, when new videos are uploaded, please feel free to subscribe to my youtube channel.
ua-cam.com/users/kudvenkat
If you like these videos, please click on the THUMBS UP button below the video.
May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please free to share the link with your friends and family who you think would also benefit from them.
Hey Venkat,
I am from Bangladesh, We people are very grateful to you :-)
Thanks mate.. :-X
I have made my work resume with your amazing tutorials ! thank you so much !!! i will never forget your kindness !
Hello SS - Wow...that's great to know. Thank you very much for all the kind words. I have included all the C# tutorial videos in logical sequence on the following page. You will also find text version of the videos and slides. Hope you will find this page handy. Good luck and all the very best with everything you are doing.
www.pragimtech.com/courses/c-sharp-tutorial-for-beginners/
@@Csharp-video-tutorialsBlogspot thank you so much, i will definitely check it !
so wonderful and amazing. I always learn from your channel if the required material is available here. If not then I search for others but first of all I come here. you are so amazing and your way of teaching is superb.
Amazing as always. Lucky to watch such tutorials.
sir, thank you so much for sharing your gift so freely to so many of us students.
if you could do a video on design patterns it would be great...
Can anyone help me understand the part with, employees = dept.Employees .. ? how did the reference of 'dept.' work ? I have seen it refer from the DbContext object in most cases.
Hi, I had the same doubt while watching this tutorial. But if we go to the tutorial portion where.edmx file is created we can clearly see that there is a relationship between department and employee entities which is shown with a connecting line. This line means that every department will have a list of employees. So that list of employees is actually created in the department class at the end as a list of property of type Employee.That's why in the loop he was able to refer Employee entity by using the dept object. I am sure this will clear your doubt.👍
Question about Var vs Type at (16:12). Is var a better option for declaring result because it's allows the logic and return value to be updated/changed, or would you in a professional setting have the type written and update it to new return type when adding the 2nd select statement?
Somehow objectives are not clear. Though great effort
how you run this on cmd?
3:17 where 4:39 10:53
11:46 select
Love it! ♥
Thanks so much Venkat! :)
you are the best!
In this tutorial you used ADO.NET entity Data Model, but in the beginning of your LINQ tutorials you used LINQ ti SQL classes. What is the difference, it seems they are doing the same thing to me?
Sir, you nailed it.... I have learned a lot from your informative videos.... BTW, it would be great if you upload videos about Gof design patterns... may God bless you
Great as usual! Keep going!
Amazing Venkat :) Thank you.
Witch part is joining two database tables "Department" and "Employee"?
There is a relationship between them. If you watch Entity Framework tutorials then you will be able to understand clearly.
Thanks a lot for this video 👍
Great as always. Whenever you have time, would you mind making a video to sort an array of students and the marks scored which are in random order. Then displaying the results with highest score and corresponding name in some web form. I am planning to develop such a project for kids in Himalayas, Thanks in advance.
plz Upload design patterns
why database query where method is iqueryable and why not IEnumerable.what is Difference Venkat sir.
Thank You
Mageshwaran K
I believe IQuerable is quite good when querying the data from database as it executes the select query on server side with all filters but IEnumerable executes select query on server side, load data in-memory on client side and then filter data. Therefore IEnumerable prepares for Linq to XML or collection objects e.g. Array, Dictionary list etc.
Another important point to remember is IQueryable interface inherits from IEnumerable, so whatever IEnumerable can do, IQueryable can also do.
thanks Kamaraju Pukala .i understand now ......
Thanks for the videos
Sir you did not explain how to use the second overload on "where" method which takes 2 parameters instead you went on explaining how select manages the 2 parameters
Thanks a lot
dept.Employess.Where(x=>x.Gender=="Male");
I don't get a thing in the above point. How does dept can refer to employees.
dept can have Id, Name and Location details according to the tblDepartment table.
But how can it shows the employees belong to a particular department.
Kindly guide me.
+Praveen Kumar if you look at the script of creating Employee table on sql server.. it has a column DepartmentID (reference key) which refers to department table. So when Entity Data MOdel genarate the database, it creates a relationship between the 2 table (on the sample, its zero or one to many relationship) because of that reference key. and it generate the navigation property. the dept.Employees is a navigation property refering to Employee table.
+Irish Jane Bulangis Thankq very much for spending your time to clarify my doubt :)
thnx a lot sir
nice
As always +1
great
I don't understand where type 'Department' (singular) came from, if the table was called 'Departments' (plural).
coop78751 Department and Employee are Model classes automatically generated based on the selected tables and these are listed down in the .edmx file. Watch video snap at 18:46.
coop78751 I believe he might be changed the name of these classes to singular form.
Visual studio is smart enough to rename the entities to make their name meaningful. We have multiple department n employee in db table Department & Employee. That's why VS named Entities as Departments & Employees. This is as per my understanding while watching EF tutorials from this channel.
I am not familiar with these symbols in C#. Anyone have a video that will help with that? Thanks
it indicates delegate method, first agrument is parameter type, and second argument is return type that delegate will.
great