Part 10 Working with multiple tables in mvc

[@sendrelamaria3336]

Again and again, I'd like to express my deepest thankfulness for all what you do for us. May "God reward you", and sure He will, and reward everybody promptly giving a sincere hand for no return. Please, don't let helping others be a reason to forget yourself and your buried personal needs and wants, if any. A greeting from the +9000 year-old land of Pharaohs, Egypt. Sincerely yours.

[@Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.

[@53nat0r]

I cannot believe the quality of the content! Much better than Udemy courses! Just for you I am not skipping an advertisements so that you get a treat out of it too! Hope you make more videos!

[@KnappStephan76]

Greetings from Austria and thanks for the tutorials, the best explained I found so far on the net!!!

[@mohamadalibrahim2995]

Du hast Recht, seine tutorials Sehr gut

[@mishaelmeshach9180]

Perfect. All of your tutorials, just perfect! Thank you, sir!

[@dawidczarnecki7456]

i had a little bit problem with understanding this lesson, so i had to check your code samples. I didnt expect what amazing job u did there. I am your fan!

[@karthikr3970]

Karthik R 5 minutes ago Hi Venkat Sir I have watched your all Videos . All Videos are unbeatable video. In my career no one can explain these method. Every day I have been checked your blogs. Please keep on post MVC video and Expect WCF. Thank Yooooooooooooou Very Much You are very Brilliants and Quickly Capture User Problem. I have lot of doubt in coding but after saw your video every thing have been fined

[@golansoffer6538]

your amazing!! your explaining those things better then my teachers!!

[@hoaleang8437]

perfect tutorial I have ever seen on youtube, Thanks so much!!!

[@Csharp-video-tutorialsBlogspot]

We will have to create a view specific model, that contains the properties from both the tables. If this is not clear, I will record and upload a video on this very soon.

[@nooriasaleem2758]

Sir, please provide link Because I didn't understand the DBset r DB context or my controller couldn't access the EmployeeContext Model class

[@MrsLAki91]

I simply love you...thank you so much ! :) great tutorials

[@fabrizioiacovone2661]

If it can be helpful...for those who had problems.. (invalid Column name) To make it work I had to spend a lot of time .. to understand that I needed to add the attribute [Key] on both of the class Id's and beside that add an attribute [NotMapped] on the property Employees in Departments since it doesnt appear in the schema.. Nice course I love it

[@BasiliskSupreme]

+Fabrizio Iacovone Thank you. I was breaking my head on the same issue

[@basharawwad5451]

Thank you So Much

[@sunpreetsingh5143]

thank you so much ...u saved my time . :)

[@JaswantSingh-go8ey]

Sir, You are God for poor Student. Thank you so much sir

[@dhliu9687]

THANK YOU sir !! you are good teacher : ) it is really helpful

[@JaswantSingh-tz9bq]

One of the powerful concept Thank u sir

[@jasonvega3987]

Thank for sharing your knowledge , Great Job , I hope you continue doing more tutorials.

[@vladimirstrukelj6587]

I owe you several of my coursegrades, thank you :)

[@Csharp-video-tutorialsBlogspot]

+vladimir Strukelj Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful. Dot Net & SQL Server training videos for web developers kzbin.infoplaylists?view=1&sort=dd You can order DVDs for offline viewing using the link below www.pragimtech.com/Order.aspx Code Samples & Slides are on my blog csharp-video-tutorials.blogspot.com Tips to effectively use our channel kzbin.info/www/bejne/r2ibYYCtnb5qZtU To receive email alerts, when new videos are uploaded, please subscribe to our channel kzbin.info Please click that THUMBS UP button below the video, if you like the videos Thanks a million for sharing these resources with your friends Best Venkat

[@foyejurrahman4331]

It's awesome. I am just learning stage. It's pretty helpful for me.

[@Csharp-video-tutorialsBlogspot]

Sure, will do it as soon as I can.

[@dsingh3205]

Thank you sir for uploading 10th part of MVC. have a great day.

[@vaibhavtrikolikar4902]

Thank you sir for another Great Tutorial

[@narendramuppa]

Awesome Video. Thanks a Lot Venkat

[@irinamurmur]

Thank you so much for this course, it's great!

[@smtaha9571]

No the tutorial is not wastage for me. I used old method os SqlConnection and SqlCommand for my work. Thanks Sir to teaching me this before.

[@guruprasady5362]

It was really nice. Thank you.

[@Boudak_17]

what an Excellent Job!!

[@arushraj]

Thanku,,,thanku thanku.. sir sooo much.....

[@sivanesansethuraman7400]

Hi Venkat, the video is very nicely articulated. I had two questions, could you please clarify me. 1. Why don't we have DepartmentContext separately to access departments ? or Why did we add both employee and department in single context ? 2. I see the employees properties in the department Model class is not used in this session ?

[@francisgonsalves4672]

Awesome Tutorial Sir.

[@Csharp-video-tutorialsBlogspot]

Hi Ipsita, we will discuss this in our future videos.

[@rahimbakashk1442]

wow .....Amazing Tutorials...

[@santoshkumarkotha1975]

excellent videos.................... thank you

[@Csharp-video-tutorialsBlogspot]

Hi Ravi, we will discuss this in our future videos.

[@TheBoozeFairy]

Great set of tutorials

[@souleyeba5036]

Thanks a lot !!! Good tutorial !!

[@wisnu7734]

good question

[@helenayschoi2710]

On Visual Studio 2013, this tutorial gave me an error that no key defined on Department. I figured it out by adding two lines on Departments.cs using System.ComponentModel.DataAnnotations; [Key] public int DepartmentId { get; set; } Thank you Kudvenkat!! Your tutorials are really helpful and easy to follow!! :)

[@MohamedEltiganiElnour]

👍 great.

[@Abc10802]

Thank you venkat sir, it's nice... plz upload wcf video...

[@hlzhang346]

thank you, it is very useful.

[@herbertrodriguez3717]

Thank you Sir !🚶🌄

[@shanmugadasskalidass6285]

Good work! Thanks.

[@thanhfighter0511]

Thank you so much :))

[@sca11ywagg]

Do you talk anywhere in one of the other tutorials about why one method sends a List and the other recieves an IEnumerable. I hope so because it is a good - and very deliberate - construct.

[@218manish]

Good job Venkat

[@shrutisoni3108]

thank u..for sharing this videos..

[@recepkarayigit8373]

I have a question, I did everythin is same except, I create a separate DepartmentContext.cs under the Model folder and of course I rearrange the code of DepartmentController as public ActionResult Index() { DepartmentContext dpc = new DepartmentContext (); List dp = dpc.Departments.ToList(); return View(dp); } I don't get any error when I execute the program, but I can't see the department either. But the way pragim's shows as use "public DbSet Departments { get; set; }" into EmployeeContext works. What am i missing? Thanks for interest and your time in advance

[@obadiahwilliams1393]

thanks for the tutorials!

[@karlladavis2213]

Amazing!

[@semikolon4229]

Very Helpful.

[@MaheshKumar-th7ji]

Hi, It's not required to add *"public List Employees { get; set; }"* property in Department model class even without this property the application works fine without issue 💯

[@panther208]

Thank You so much good Tutorial

[@kenmtb]

Great tutorial. One thought: Why did he create and use an employee context in the DEPARTMENT controller?? To get the initial list of departments, wouldnt you use a department context that also has a list of employees and use that in the department controller???

[@shabit]

@ Priya Bhatia..Hi I went through the same issue..like Invalid column name Department_DeptId ..first I tried to create foreign key constraint ,then i seperated departmentcontext from employeecontext model and created another model for department context.Now its working fine...Hope this will help solve ur problem too.

[@ukaszwesoowski2186]

Thank you, sir. It's working.

[@casper6060]

Thanks that helped me :) so annoying that because i am running with VS 2012 and Venkat is running with 2010 i think that things are different in small ways like this, but without these videos i would be 100% lost so my greatist respect to Venkat for making these godly tutorials!

[@CalibrationExtreme]

Great stuff! I'm unclear on one minor detail and it's something MVC is doing... the URL being generated for the DEPARTMENTS list have a parameter at end to get to the EMPLOYEE list as something like "?departmentID=3", but when you get to the EMPLOYEE list, the parameter to get to the DETAILS uses just a slash as in "/4". Why does one "html.actionlink" generate links with the question mark + parameter name and the other "html.actionlink" generate only with slashes?

[@JitendraSingh90]

Hi Venkat, I am doing the same thing but getting one error "Invalid column name 'Department_Id'. " on line List employees = employeeContext.Employees.Where(emp => emp.DepartmentId == departmentId).ToList(); I have checked there is no column named as Department_Id in code side and database side as well. Could you please help me in this. Below is SQL Profiler Trace: exec sp_executesql N'SELECT 1 AS [C1], [Extent1].[EmployeeID] AS [EmployeeID], [Extent1].[Name] AS [Name], [Extent1].[Gender] AS [Gender], [Extent1].[City] AS [City], [Extent1].[Department_Id] AS [Department_Id], [Extent1].[DepartmentId] AS [DepartmentId] FROM [dbo].[tblEmployee] AS [Extent1] WHERE [Extent1].[DepartmentId] = @p__linq__0',N'@p__linq__0 decimal(1,0)',@p__linq__0=1

[@muhammadhassan3058]

Thanks 😊 sir

[@praganeshpatel9368]

Thank you for your your great introduction to the .net technology, but i would say that you should update your videos regarding new updated version of VS2013 thank you

[@nasarazam]

Praganesh Patel Thanks him for all the free videos instead of asking for more. You do realize that it take an awful lot of work and effort.

[@divewithshubham]

sir In mvc4. line: public list departments { get; set; } In department model is creating an error.. removing the same works perfect. Is there any reason of putting that line there?

[@raghavendrajha5310]

@kudvenkat: Please explain this.Thanks

[@ACLAproductions]

I was also getting an error and removing that line solved it. Anyone has found an answer yet?

[@loyalcitizen8713]

try this, public List ListOfEmployees = new List();

[@1234mohitmhatre]

It worked thank you so much Bro

[@amland3878]

Nice learning thanks, a little back-tracking/trouble shooting/reverse eng type of learning... kind of 'lets do this-not working-why-because we missed that-still not working-why-we missed that too'... a not-beginner may remain confused until the exact steps are revealed at the end... finally feels like if I could play the entire video in reverse direction just to sum up the basic idea.... still good for me, thanks

[@tornikeonoprishvili6361]

gr8 vid m8. tnx

[@mahmoudadel9799]

Thank you so much

[@amjadaslam5270]

sir i love your all video. some time i need extra help

[@Cranberry1669]

Hi Venkt, Question: Do you have a similar video where backend is simply an XML file but not a SQL server database? I will be working on a UI where there is no database involved. the Data will be pulled from an XML file. Or Do you have any other suggestions? Thank you

[@mabdallah57]

thank you for all sharing

[@abubakarizhar5608]

Very well described . Can you please tell me , should the new route parameter in ActionLink match the input parameter in Controller method for which ActionLink is called. e.g departmentId parameter.

[@Funkyoo4]

So what's the use of forenkey in between this two table

[@iamsk6353]

in which order we can watch the video play lists... so that we can be able to develop a web application using ASP.NET MVC???? Plz tell me sir.... Thank u in advance

[@jcrtec]

+sudhakar badiger Start in video Part one.

[@belearnt3902]

is this using entity framework? or simple mvc ?

[@bwboy668]

You added a list of employees in the department class but I don't know how you used this list. Can you please clarify it?

[@jrao77]

Hello, I have one question. Using this method how can we show Data from two tables in one view. For example if we want to show Department Name on employee Details Page how it will be possible

[@nghuwei]

Hi. Can I do this tutorial on .net core? There is not much tutorials from kudvenkat on asp.net core mvc so I will use this as reference.Please advise

[@miltonsibanda4540]

this is fab, is it possible to do something similar with the create page? so from the department list page if i click create new employee it fills the department field automatically?

[@sayalichopade1270]

Why do we need to use @using and @modal both for accessing modal properties? is there a difference in them

[@michaelsipayung]

hello bro .if u getting error checking your table data , u must have 4 field in tblEmployee(EmployeeId,Name,Gender,City,DepartmentId).

[@priyabhatia1165]

I got stuck in a problem while working with multiple tables in mvc. In my project sample, I created two tables Employee and Department but when I pass dept id to employee controller in index, I am getting sql exception "Invalid column name Department_DeptId". When I debug my code I saw EmployeeContext schema is creating one more column in Employee class named as Department_DeptId. I dont know from where it is coming. Please suggest. Your help will be appreciated. Thanks in advance

[@prashantmanandhar2440]

really great!!! how to do the same thing in asp.net webform?

[@gulshansinghmetharu]

The resource cannot be found. When I go to department/index page. Please help.

[@ZappFoot]

thank you

[@ronald070687]

Hi, can you help me? i am having an "Invalid column name 'Department_ID' error when running the project.

[@rahultambekar6110]

the same problem i have facing?

[@nikhileshr4446]

Rahul Tambekar u need to modify the employee model. add a new column departmentid. pls see the table structure in the first part of the video.

[@pranaypandu9268]

@@nikhileshr4446 even it is getting

[@samathaknr5462]

Even if we are not declaring Employee class under the Department class also its working. [Table("tblDepartment")] public class Department { public int Id { get; set; } public string Name { get; set; } //public List Employees { get; set; } } What is the use of declaring this Employee class under Department class ??

[@heemelhimaddri534]

Sir, Recently i started to watch this MVC series but unfortunately in part 10 I'm facing some exception problems and it occurs in Department Controller. Here below I've provided this line List departments = employeeContext.Departments.ToList(); which throw An exception of type 'System.Data.Entity.ModelConfiguration.ModelValidationException' occurred in EntityFramework.dll but was not handled in user code Additional information: One or more validation errors were detected during model generation: I've tried so many time but i couldn't fix this problem, so please help me to handle this exception. Thank you

[@nitesh.kumarsaw]

From where departmentid is coming in Employee modal. as I saw the tblEmployee , there were no property called departmentId. Could you please explain?

[@KaushikPoojari]

You will have to create a new table of Department (Id, Name) and Add a new Column in Employee Table with the name of DepartmentId(which would be Foreign Key) and linked to ID of Department Table

[@jrao77]

Hi, Thank you very much for your reply. I have done that but it does not work. It will be great if you can upload a video or post a simple code to your blog giving Department name along with employees.. Thanks again

[@bravitejas]

thankyou sir and How to implement dropdownlist in mvc

[@MrJose1196]

What is the purpose of the DbContext?

[@imyounick]

Why we have to create different view for each method ? is there any way we can use one view with multiple methods ?

[@kalyanidotnet5905]

hi venkat sir one small request from my side i want to devlop a mvc application there wcf is acting as a bussiness logic tier and ui will be mvc plz give us a vedio with mvc ui and wcf as bussiness login tier and jquery for validation plz sir.......................

[@qimingcheng7306]

What is the use of List Employees property in Department Model Class?

[@nitinvmahajan2006]

Hi, Where can i get copy or script for Sample DB database that you are using in the tutorial.

[@abdomohmed2038]

but is this a good practise to show the the id of the department in the get request ?

[@rezataba6204]

*Solution for these issues:* *1- Invalid column name Department_DeptId* *2- Invalid Key* *3- Entity issues* Using [Key] or Foreign Key didn't work. *1-* Change your EmployeeContext file to something more general. For example: *ProjectContext* *2-* Now In *ProjectContext* file create two classes which contain your EmployeeContext and DepartmentContext as below: using System.Data.Entity; namespace MVCDemo.Models { public class EmployeeContext : DbContext { public DbSet EmployeesContextTbl { get; set; } } public class DepartmentContext : DbContext { public DbSet DepartmentContextTbl { get; set; } } } *3-* Modify your Web.config file. *4-* Modify Global.asax file: Database.SetInitializer(null); Database.SetInitializer(null); *5-* Now you can use your connections for EmployeeContext and DepartmentContext separately. I read somewhere since Vinket was using Visual Studio 2010 there was no issue. However, it seems this issue started with the newer versions. Good luck. Reza

[@sefatanam]

:)

[@SHIVAML987]

Thanks. God bless you :)

[@shaikhshaji]

Thank you very much, it really helped me.

[@shailendraphadke5557]

Before creating Depaertment, Model my it was working very fine. But as soon I have written for Department I am getting this error : One or more validation errors were detected during model generation: \tSystem.Data.Entity.Edm.EdmEn­tityType: : EntityType 'Departments' has no key defined. Define the key for this EntityType. \tSystem.Data.Entity.Edm.EdmEn­titySet: EntityType: EntitySet 'department' is based on type 'Departments' that has no keys defined

[@Algebrodadio]

Is it necessary to have a separate file for each model class? Since the classes "Department", "Employee" and "EmployeeContext" are all in the "MVCDemo.Models" namespace, couldn't you put all three classes into the same file? Why wouldn't you do that?

[@RyanFaeScotland]

Aaron Wolbach Haven't watched any of the videos in this series yet so not sure what these classes are like but a general reason is simplicity and readability of the code. You may think 1 class is easier to manage but someone who doesn't know your code who is asked to make a change to the Department class is going to struggle to find it if it isn't in its own file. IDE's make life a lot easier so this is less of a problem but you should still aim to have things so clear that they could be read in notepad / Windows Explorer in a pinch! After all, you could put ALL your code in one file but you wouldn't, would you? (O.o)

[@bradleyr4451]

+Aaron Wolbach It works out much better if you dont make one big file. I created a large, "flat" table with 300 columns, all in one big model class. And now after months, I have to rework the entire project and split the table into probably 10 tables and redo everything. there is a limit of 8060 bytes you can load into sql server per row, not very much. Find out things like this after the fact. Thought it could store 1Mb or 2Mb+ pdf documents along with other data? 8060 bytes is a barrier that can cause your system to fail when users try to store or update data. There are classic methods of how to split your database, group by function and by access, etc and it works better (doesnt crash) and should run faster. but you can put this all into one

[@matheshwaran602]

nice , but what is the use of = public List[Employee] Employees { get; set; } ? without this also i can run the same output

[@Mousesenpai]

List is a class which holds data in list form, u better understand the basic of c# in order to jump in the mvc

[@buskilamaor9587]

It works fine on the local machine but how do i make it work after publishing to IIS? there has to be a change in the connectionString.....any help?

[@shashikiran5388]

When we implemented action link from EmpList to Emp Details URL is with slashes. But when implemented action link from Departments list to Employee list why is that with question mark(querystring)

[@shashikiran5388]

may be because travelling to other controller with a parameter to pass on

[@LalitJindalLonelyStar]

how i define foreign key in emp table... please rply

[@AvezMohamad]

Alter table tblEmployee add foreign key (DepartmentId) references tblDepartment(Id)

[@ipsitapani8641]

ok.THANK U SIR.

[@meghamisra5622]

How can I use join query in the model to show data on view?

[@justinsheroz3249]

sir i have a error of unhandled exception how i solve this.... Server Error in '/MvcDome' Application. The parameters dictionary contains a null entry for parameter 'departmentId' of non-nullable type 'System.Int32' for method 'System.Web.Mvc.ActionResult Index(Int32)' in 'MvcDome.Controllers.EmployeeController'. An optional parameter must be a reference type, a nullable type, or be declared as an optional parameter. Parameter name: parameters Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.ArgumentException: The parameters dictionary contains a null entry for parameter 'departmentId' of non-nullable type 'System.Int32' for method 'System.Web.Mvc.ActionResult Index(Int32)' in 'MvcDome.Controllers.EmployeeController'. An optional parameter must be a reference type, a nullable type, or be declared as an optional parameter. Parameter name: parameters Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

[@secretlives2734]

justin sheroz did u solve it...mine also same error..if u solved plz reply

[@mikheilshalvashvili2605]

Justin I have the same problem

[@nagihanozcelik5290]

Did u solve the problem?

[@mikheilshalvashvili2605]

I reslove it bro

[@justinsheroz3249]

how