Part 11 Using business objects as model in mvc

[@aiyka_music]

Previously in your models folder you had a Context Class which had properties of type DBSet. Is that not required over here anymore? Why not ?

[@wolv12458]

Because he implemented his own data access logic here using ADO.Net instead of using the Entity Framework used perviously, which is where the DBSet derives from.

[@egl2004]

I thought that every video built on the same ongoing example as the one before it. Is that not the case? He's using the same name, "MVCdemo". I'm struggling with the connection string issue as well. ??

[@jerds_6885]

If It can help you, I'm using this connection string in web.config file at the root of the project and it's working well for me:

[@8starsAND]

Really appreciate your work. People like you can change the world, it's really important for me to share your experience to the others, not necessarily for money. Thank you!

[@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.

[@naodagere8210]

One of the many unique features of Ven ppts are how they are connected (flow). He show us the problem in the preceding part and present us the solution in the upcoming.Great Work!

[@MegaEengineer]

THIS GUY IS A LEGEND - I recommended his videos to everyone. Fantastic 10 out of 10

[@premasuthar8023]

Everyday I watch one tutorial and it teaches me alot... thanks for such an amazing tutorials. God bless you Venkut.

[@alejandrojimenezvalverde269]

I've learned so much with all your tutorials. Thanks for share your knowledge

[@vipintp4118]

All ur videos are superb... very useful, easy to understand. thank you very much.. God Bless

[@lavishrich]

i am moving to mvc been looking into how logic is written in mvc and the 3 tier architecture.....this video helped!

[@niclasj2373]

I just signed in and created a account to say Thank you!

[@mihrabhena3550]

your videos are really helpful. Its better to watch your videos here than to pay money on online tutorials.. Thanks

[@MKhizarBajwa]

Hello I have an ambiguity that as EF bulid on ADO.net then why we are using ADO.net instead of EF .....? this making me really confuse ........ Kindly replay ASAP Thank you

[@remiduplan8449]

no worry, he shows different way to do it the EF way, and the Ado.net way.

[@techtalksabhishek]

The only reason to use EF is to make use of abstraction and to make use of strongly typed models. If we use ADO.NET we need to be cautious as no compile time errors can be caught. Lets say you have made an error in SQL query while performing an ADO.NET action this error can only be caught at runtime as this error will be thrown once the call goes to SQL server. Such kind of issues can be avoided if we use EF. EF has its own limitations as its not good for handling operations on huge datasets. If you have huge datasets its always advisable to use ADO.NET. You can also try using Dapper from Stackoverflow as I heard its really good ORM alternative to EF.

[@jasonpacia7603]

Tnx sir Kunvenkat, First I run into problem regarding the connection string, but when I visit here, I realize that I forgot to go into step 7..... You're are really great. Thanks a lot....

[@sandeepmittapally2289]

hi sir am getting issue (10:44 )when am adding business layer reference to Project,it will not adding

[@shariaretanvirakash8716]

sandeep mittapally i am also facing the same problem. u solved this problem? please help

[@ashwinsudhini]

u made things simple n easy...good job..very helpful

[@babitapoola8041]

i have tried this tutorials m getting an error on the line SqlDataReader rdr = cmd.ExecuteReader(); called An unhandled exception of type 'System.StackOverflowException' occurred in System.Data.dll. plz help me out!!!!

[@vladimirx84]

I have the same /&/((&#$ problem, Can you resolve it?

[@ShavetaChatak]

babita poola Check your EmployeeBusinessLayer class, and check what you are returning. it should be List object, you are probably returning property itself (may be type mistake)

[@egl2004]

Hello Venkat. Thank you very much for these videos. I greatly appreciate it. Is there a quick way to determine in the beginning of the video if it's a continuation of the same app from a previous video or if we're starting a new app? In Part 11 of MVC the app still has the same name and the prerequisites are listed as videos 8,9 and 10....however, the connection string is different, tblEmployee is different and most of the work done in the prerequisite videos isn't there any longer. That makes sense if it's an entirely new app......however, it's not really possible to tell that until you're already through a lot of the video. Am I missing something?

[@haydarm.al-samawe9819]

Maybe i come for this coerce too late but i really like the way how you give the information from A-Z , i just have one question now after almost 4 year from this coerce did we really need to use business objects ? or just using MVC even now i read about not using Stored procedure it can be ? if i use MSSQL

[@stevenchi1202]

Best tutorial for MVC in the Internet

[@TopGamerTom]

Venkat Sir, is there a specific reason to use business layer class, couldn't we do the same job using List like in your previous video by creating a new video to display the data in a table?

[@bunthaideng2492]

Hello Sir!! I wonder one thing, In BusinuessLayer why didn't you use DbContext to store data retrieve from sql server? I think this way should be more easier than write much code.

[@luisespinoza9093]

Very usefull. There are many tutorials that usign entityframework but is powerfull know how to build applications from scratch. Thanks

[@Snapken]

13 dislikes? idiots.. idiots everywhere.. anyway,. awesome job, You are my personal hero :)

[@mad_t]

Maybe those are people who try to give same material for a fee, and venkat is ruining their «business» =)

[@impossiblehousemarylandsta6266]

@Snapken and @Tim , Let me explain that for two morons, I m giving thumbs down 2 years later after your comments, so listen carefully. This should be beginning tutorial, but even me (I know Mvc for 5 years but used it long time ago so I need to refresh my knowledge that`s why I m here) not getting what Kudvenkat is doing, he is not explaining well and copying and pasting some code. His last two tutorial also got thumbs down from me because he does not explain about connection string but he jumps in subject to subject , I spent 2 days to connect Mysql database after watching last 2 videos. I got several errors with same code. I like Kudvenkat videos sometimes it is good (given thumbs up), sometimes they are not good (given thumbs down). I do not care those two morons what they think but I want people to show how people who give thumbs down , can think. So before being ass hole, just focus on your job, not criticize people with your small brains

[@nayeemhasan7444]

when i am trying to add the business layer refernce to the mvc demo..it says it cannot do it due to a circular dependancy .. what might be the solution to that ?

[@hossamyasser2866]

in 2016 you are the best thanks a lot

[@dipikabhagat5252]

While creating strongly typed view for EmployeeController.cs ,The model class intelligence is not giving BusinessLayer option . Only 2 options :- FilterConfig, RouteConfig .I have already added BusinessLayer reference to my MVC proj but still not working . Anyone please help me with this .

[@iHamzaKhanzada]

Build the solution

[@syedshah6166]

Having same problem...even i rebuild the whole solution

[@automation_jeff]

Your video's have been very helpful, although they are five years old. Was wondering if you were planning any updates, things have changed in recent Visual Studio's versions 15 and 17?

[@laxmibajjara2461]

Thank You so much for these videos. It is very helpful to naive users.

[@shemeemsha]

Hi Venkat.. I have a doubt.. How to call a http Post controller from another controller.. :)

[@dsingh3205]

Thank you sir for uploading the 11th part of MVC. HAVE A GREAT DAY.

[@imranbhatti7906]

good work done kudvenkat , awesome

[@streetzstudio100]

Please i ran this code and i get the error Object reference not set to an instance of an object. on line 16. List employees = empBusinessLayer.Employees.ToList(); what could be the cause i am using visual studio 2015

[@streetzstudio100]

i got the solution. the problem is that i put my connectionString in the web.config file inside the view directory. then copying the connection string and pasting it to the web.config file under the project directory fixed it. thanks

[@bankniftydailylevel2119]

all videos r great thanks to guides us................................. thanks a lot

[@Csharp-video-tutorialsBlogspot]

+Sandeep Mishra Thank you so much for accepting my request 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

[@MagnificentKnight1]

+kudvenkat Sir, on the view @foreach (var item in Model) the model is null and throws a null reference exception, how do I solve it. Thanks.

[@MagnificentKnight1]

+kudvenkat Sir, I've solved it, it was my fault.

[@MagnificentKnight1]

+kudvenkat, I didn't pass the Employee list's object to the View method.

[@nisargdesai1044]

Hi sir your lectures are very useful. Every single details is explained in all the videos. I just have a single query. It shows an error like "Object reference not found" at line "string connectionString = ConfigurationManager.ConnectionStrings["MVCDB"].ConnectionString;".I have tried every possible way to sort this problem, Please help me.

[@OnBurak1]

I am getting the same error

[@OnBurak1]

I realized I made a mistake with the connection string name and corrected it.

[@adamkazimierak715]

You need to add reference to System.Configuration in your BusinessLayer class library

[@mappalaraju1]

At the end of webconfigfile before Retrieve server name and Dbname form your Db properties permission settings Check this MYSQL-security-login-NTAuthority\system\properties\serverroles\sysadmin (if it not working)

[@PraskYoutube]

Hi Venkat thanks so much for this.So just 2 queries. 1.We cant use DataTable for this? 2.Can we call the stored proc from the Model pass it to controller and then from Controller to View?

[@bradleyr4451]

Hi Venkat, could you please do this again using visual studio 2015 ? we cannot follow directly, right click on Index and its not the same, you dont add controllers the same as before

[@carlossiverio3570]

I cannot find anything in the referencing when creating the library class is this a VS 2017 thing?

[@csabasomogyi6780]

this is my also problem

[@maximss]

Hi, I'm getting an error here: EmployeeBusinessLayer wtv = new EmployeeBusinessLayer(); List employees = wtv.Employees.ToList(); my "wtv" variable is not recognized as being of EmployeeBusinessLayer class, any clues? thanks

[@maximss]

someone? :(

[@lovegeorgian]

I got the same. To close and open Visual studio resolved it. I googled and found some other solutions also...

[@BasiliskSupreme]

Hi All, Need your assistance on an issue I'm facing. I am able to to load the data from the DB using the class - EmployeeBusinessLayer, but this does not render on the the Web-UI. I have the exact copy of Venkat's code, from the creation of the view from the Employee controller. but this is still not working. Have you done something extra to make it work. Best Regards, Sitaram.S

[@Namishmedia]

Hi Sir, I am using VisualStudio2019, as there is no web.config file, i couldn't save the connection string. pls find a solution for this.

[@surabhisinha6882]

Awesome video .Really helpful

[@Indianmemetemplate]

How to use class library as a model to submit data with notation validation

[@NAWAABJADA]

Getting an error: Line 28: Line 29: @foreach (var item in Model) Line 30: { Line 31: System.NullReferenceException: Object reference not set to an instance of an object. on Index.chtml Can you please help?

[@lovegeorgian]

Did your action return View(Employees) or just View()?

[@oraksoft7471]

Great answer

[@angrishdeepty]

Mind blowing sir... really gr8 videos...

[@gauravsingh-hr6fn]

venkat sir i need one help i create all the thinks as expected but when i am creating Employee Controller i am unable to create object of EMployeeBusnessLayer Pls Help

[@edsalazar4590]

Thank you for these videos. Much appreciated.

[@komaldhere5990]

Hello sir, why class library is not added in controller. I am getting this error while importing class library in controller.

[@nani143144]

Hai sir.. Your lecture is mind blowing, really great great great sir. i have no words for how u way of explaination. simply awesom sir.. Iam waiting for WCF Sessions sir. is there any chance to put sir...????

[@linxploit]

i faced this error i googled but... An unhandled exception of type 'System.StackOverflowException' occurred in System.dll

[@Itachi2706]

Just had convulsion when you deleted Model folder...

[@pahadi_bhula_]

hello sir i am getting this error i have tried everything but not able to correct it. Please help.......... An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code Additional information: Could not find stored procedure 'spGetAllEmployees2'.

[@sca11ywagg]

Just an aside, any adherence to naming standards, interface inheritance etc. is purely a Microsoft convention. There's no such requirement in the original MVC pattern, which pre-dates Microsoft by several decades.

[@davidespada01]

Hi MR. Venkat Same Question of @Prashanth Krishnan Thank you

[@explorewithdawa]

First of all, thank you so much for such a wonderful tutorial. I have followed your process and everything went smoothly but in the end, something seems went wrong. I'm able to bind the data in the view list with no exceptions. I check my code by setting a breakpoint and there are 15 different data in the IEnumerable list but the data at row 15 is repeating itself 15 times (the last one). Can someone help me regarding this?

[@honghaivib1977]

Thank you very much, Your video help me alot

[@linxploit]

hello Sir Thanks for Sharing Your Knowledge

[@kamdemkakengne]

Nice ! Thank you so much sir!

[@amarpreetsingh6016]

the ado.net code is working. the connection keep going in circles in get accessor and throwing stackoverflow exception

[@mayashobana7880]

I have doubt for every Controller we have to create MapRoute in RouteConfig?can anyone help me in clearing it?

[@kenmtb]

The MapRoute in RouteConfig allows you to determine the default controller/Action Method and parameters that are read from the browser's url. Without the MapRoute you would have to specify all of the information explicitly each time you ran your web app.

[@tiensinhphan5173]

System.Data.SqlClient.SqlException: 'Could not find stored procedure 'spGetAllEmployees'. Please help!!!

[@opsekai3599]

where model and modelItem came from !!

[@dhanashripatil5665]

Very useful video for all beginers

[@hoaleang8437]

thanks so much! Can you make some tutorials for applying existing layout for the view?

[@masood0092]

error at Line 26: con.Open(); can any one reply...

[@firdousabrar1498]

Great Tutorial sir...

[@romesupaila1864]

I got error.. uncaught exception thrown by method called trough from Hresult 0x80131604

[@dhoniomkar]

Hello sir this is omkar. I am very much new to MVC .i want to build a project in three tier in MVC 4 .So please help me

[@amarpreetsingh6016]

its resolved. i was calling property. thanks.

[@jhonhernandez9210]

I have used this connection string and works

[@MrVibhore1989]

I got output of this in my system "Successfully Implemented" , Now i can die in peace. BTW I have never seen the face of the speaker even searched on google it was not there, Is it a real human , or I am following the Voice of God :)

[@a.b_shots]

Someone might get error while adding string connectionString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; Even when you type the reference using.System.Configuration; If you guys face this error, go to menubar and click project. There you will find "Add Reference" click on it. It will starts with the active tab of framework. Don't change it just scroll down and look for using System.Configuration. Check it and then it will work. If it doesn't try it again next time it will work for sure.

[@sridharyadav3054]

In the view how he is managing to hide Employee ID text box object

[@bharatgambhir]

I don't agree to have model delayed from MVC. Instead we must have separate business entities and model should be typecast and passed to BAL

[@kenmtb]

Interesting idea. Where should each model exist?

[@mxgundy1916]

Don't you love how he doesnt tell you to start a new project, or to delete certain folders or even how to make your db? He assumes you already know how to do all that? Incredibly frustrating.

[@lightyagami5776]

sql codes are in his blog, link in desc

[@parko1965]

...confused now, cut, paste, errors, cut, paste, errors etc.

[@battulasandeep98]

thank u sir

[@mahendrabhoi9011]

Thank you sir....

[@agotrader960]

Very thank.

[@Exploreepic786]

Its Coming Out of While Loop !! while we reading using While loop

[@jangear]

thanks

[@ashishsuthar3827]

nice

[@poppyleo9866]

System.core 4.0.0 error: anyone?