Part 6- ASP.NET MVC Database Connection Using Entity Framework | Connect to SQL Server database

[@aapkanigam]

Click on thumbs up🖒 button if you like this video. 👉Subscribe our channel for real time MVC videos. And don't forget to 👉share this😁 Thanks💖

[@amanjutt1591]

hello sir I am following you you are doing well I have a little confusion can you help me?

[@itsumokokoro5166]

The test connection alert sound 3:35 , shocked me.

[@aapkanigam]

+Iicir Yves Exiomo I was also shocked while making this video

[@49NICOW]

I think i'm dead too

[@ronjones1587]

my hair stood up that time

[@LetCode96666]

I just shit myself lol XD

[@kiennhanmeffu2678]

Can you explain me actually what happening here from 8.19

[@mohanmani4245]

HOW TO GET MULTIPLE DATA IN DB CONECTIION

[@sohailakbar7577]

Nice video. Easy to understand.

[@CommanDoHighTech]

for every one how have Exception in (x=>x.ID) you make the relationship in a wrong way you will make relation between Department Table and Employee the foregin key will be in the table employee CREATE TABLE [dbo].[Employee] ( [ID] INT IDENTITY (1, 1) NOT NULL, [name] NVARCHAR (MAX) NULL, [Dep] INT NULL, [addr] NVARCHAR (20) NULL, PRIMARY KEY CLUSTERED ([ID] ASC), FOREIGN KEY ([Dep]) REFERENCES [dbo].[Department] ([DepID]) ); or in the sql query you will make it departmentID int references Depatment(DepID)

[@vishnuc4661]

Hi, ashish actually in mac os sql server studio management is not avilable ,can u suggest any free alternatives

[@dharmenderkapil]

I didn't Understand the Part 5 of mvc it was not so cool Sorry!!!! :( :(

[@ElPeppito]

3:34 jesus fucking christ i almost had an heart attack

[@bhaskarkholiya8125]

Hi, i can't see Generating from database option in ADO.NET Entity Data Model. Please help i am using ms sql server 2008 and visual studio 2015

[@hamzahahmed8657]

Thank you, bro

[@ewomaanthony3655]

Am having this error Error CS0029 Cannot implicitly convert type 'MVCTutorial.Models.tblEmployee' to 'MVCTutorial.Models.Employee'

[@iftikharhussain1823]

how to create forign key between employee and department tables

[@aapkanigam]

Part 26 can help you

[@Abedi000]

Very helpful video - I suggest try to drink some water beforehand so we don't hear your mouth while talking

[@aapkanigam]

+Christopher thanks for ur suggestion .. the mic was so closure to my mouth .. and did not have idea about quality ..but no worry .. after part 10 you will find good experience

[@kirankumari-nz8lr]

Thanks it helped me a lot. Loved you series.

[@trr5088]

Ashish, your name indicates a blessing and your help has indeed been that for me. On to number 7

[@aapkanigam]

+TR Rooks keep it up !

[@mattgrannen2]

Thank you Ashish: You saved me a lot of time

[@fariatam9153]

hello,nice videos :) but im facing difficulties while creating entity model from database which is on 2.40.i dont have the option "Generate from database".I used visual studio 2017 as i didn't find 2013 version anywhere.how to solve this problem?

[@trr5088]

Ashish, I am starting Part 6 - Asp.net MVC Database. Should this be a new project? Before we have always built on previous lesson.

[@aapkanigam]

+TR Rooks (TRR) no need to create new project .you can work on same controller .just create one more method and start . Technotips now on fb .you can visit fb.com/technotipstutorial .please share videos among your friends and help them too.thanks

[@erfanmehrvash]

Hi Sir, Is it possible, share the code? Because I have some error like The name 'model' does not exist

[@sanaullah-my2tm]

sir i am getting error in view when i want to write @model mvctutoral.models.EmplyeeViewModel then it is showing error the type name models does not not exst in system.web.mvc please solve my problem

[@aapkanigam]

Name is case sensitive

[@faizakhan6724]

It's giving me the following error: The parameters dictionary contains a null entry for parameter 'id' of non-nullable type 'System.Int32' for method 'System.Web.Mvc.ActionResult Index(Int32)' in 'WebApplication1.Controllers.EmployeeController'. An optional parameter must be a reference type, a nullable type, or be declared as an optional parameter. Parameter name: parameters

[@aapkanigam]

+Faiza khan in you db table the id column can not accept null value. If id column having primary key then also make it auto incremental. When new entry is save the id will automatically increased. For making auto increment watch part 26 . It will also help you to create new table with relationship with other.

[@faizakhan6724]

oka Sir will try it again... Thanks for replying

[@nguyentamtoan]

why do you have to create class EmployeeViewModel? no EmployeeViewModel, the application is Ok.

[@aapkanigam]

No, it will create lots of problem .. your view will be tightly coupled with entity classes. If you refresh your Entity framework after having any change to db schema, your view will be impacted

[@meghamisra5622]

error in this line Employee employee = db.Employees.SingleOrDefault(x => x.ID == 1); An exception of type 'System.Data.Entity.Core.MetadataException' occurred in EntityFramework.dll but was not handled in user code Additional information: Schema specified is not valid. Errors: The relationship 'Test_TrainingModel.FK_Documents_Employees' was not

[@aapkanigam]

+Megha Misra I think problem is in your table relationship in db . Make sure you have properly updated you edmx file with latest changes in your db table . Part 26 and 25 will help you to do this.

[@faizakhan6724]

Sir same error in my code... I have done it two times but same error... :( Any suggestions?

[@narendarsingh4672]

great

[@SanjayKumar-hc6iu]

Hi Ashish...I am Unable to create relationship in "MVTutorial.edmx" file.Could you please guide here how to Create Relationship between Department and Employee Table here????Appreciate you Kind attention...

[@aapkanigam]

+Sanjay Kumar part 26 will help you

[@SanjayKumar-hc6iu]

Many Thanks...Let me Complete Upto Lab25..

[@robelbeyene84]

Thanks for the wonderful tutorials. I got this error though: + $exception {"Object reference not set to an instance of an object."} System.NullReferenceException I'm using VS2017. How do I solve this issue?

[@aapkanigam]

+Robel Beyene this error comes when null value coming in your variable and you are using it some where . May be you are not getting data in your ViewBag. And you are using it on view page and doing iteration on it. Also make sure to check correct key and value pair .

[@Mulllll]

hey ashish. Your tutorials are great and helps me a lot. even i do everything like you i get a error: "System.NullReferenceException. the object reference didnt define a object instance" something is wrong with the instancing of employee oder employeeVM. I am working with a local sql db but i think that is not the problem. Any Ideas? i am frustrating so much

[@aapkanigam]

Sorry for delay in response, You can get the code from the link given in description. If you find any difficulty the please free to ask ,, thanks

[@krishnaparab9747]

How to add update & delete Events in Calendar in MVC ?

[@ramanjulureddy2458]

Do you have any Git repository for this...

[@ounly5094]

Hello sir! Can you help to create a video for search data using textbox?

[@aapkanigam]

Please watch part 37. Thanks

[@srijanghosh4367]

hello sir...my sql server database table could not show in my model.tt. what can i do ???

[@aapkanigam]

+Srijan Ghosh watch part 26 , you will get some idea

[@suerbarsylmaz9792]

arkadaşlar bu linkten en güncel haliyle okullarda gösterilen veri tabanı uygulamasının

[@aapkanigam]

+Suer Barış Yılmaz can you please write this in English

[@someone418]

nice tutorial. if we have to create many function then how will we call this function n where.

[@aapkanigam]

+Priyanka Gupta are you talking jquery or c# function

[@ender2999]

Jump scare at 3:35

[@aapkanigam]

Loz😅

[@logingoogletesttest6690]

how to login with google and fb in mvc and save data in db ?

[@bobtaylor1577]

i do not have any server names. Dude you are skipping alot of stuff

[@aapkanigam]

Nope

[@sunnyjagtap1171]

sir you dont have video on database connection without entity framework...Ado.net??

[@aapkanigam]

Nope..

[@dulajudayanga4050]

@Model CREATE_MVC2 hello sir when I try to add like this in my view Index.cshtml , I can not see any intellisense plz tell me how do add my model clz to view index

[@aapkanigam]

+Dulaj Udayanga it should be @model not @Model

[@dulajudayanga4050]

thank you so much great answer , I have watch so many videos in KZbin to learn MVC but not anyone to teach like you , thank you so much , Have a Great life Sir

[@aapkanigam]

+Dulaj Udayanga thanks.. keep learning and sharing

[@lifet4800]

hii ashish,is code first approach or entity framework is better..?

[@richievrutaal6152]

Thank you, this example worked for me.

[@jayendraadam4133]

may i know sql datatype which is used here for Employee_Id

[@aapkanigam]

+Jayant Adam its an integer

[@reyneermoisesmoralesleon6062]

i get this error: Object reference not set to an instance of an object.

[@diogoteixeira9863]

How do I do if I want to output all the data from the database?

[@aapkanigam]

Db.TableName.ToList ()

[@air32k]

Hi! Do you have a tutorial for creating this database and inserting data into it on SQL Server management tool? This should come helpful for continue this tutorial without getting help from other videos from YT except this tutorial.

[@aapkanigam]

+Spectral501 part 26 might help you ..

[@air32k]

Thanks

[@learnbydibya]

Sir, can we use MVC with ADO.NET connection?

[@sandoval3265]

Yes, you also can use LINQ to SQL.

[@meghamisra5622]

I want to create a report using join query. in SQL server I can use join query and get the report but I want the do same thing in MVC5 can you please tell me how to generate the report using join query in MVC and also tell me what is Migration in MVC I saw many posts saying that if you update table or database u need to use migration. If there is data in existing table I may loose them if I use Migration right.

[@aapkanigam]

+Megha Misra Use linq query to implement join in mvc

[@meghamisra5622]

ok Thank you for your quick reply. Do you have any video of linq?

[@aapkanigam]

+Megha Misra No right now I don't have..you search on google on linq join queries

[@meghamisra5622]

ok Thank you so much for your help

[@aapkanigam]

+Megha Misra Welcome..keep learning and sharing

[@Part-II]

Sonic BOOM at 3:35 :E

[@assiadehmani5000]

thanks for this video i have a problem in the(x=>x.EmployeeId == 1) in index page , can you help me ?

[@aapkanigam]

+Assia DEHMANI yes please.

[@assiadehmani5000]

error in this line Employee employee = db.Employees.SingleOrDefault(x => x.ID == 1); exactly in ID Any suggestions please ?

[@aapkanigam]

+Assia DEHMANI Its seems to be correct.. but what error are you getting. Try to use var employee = db.Employees.SingleOrDefault (x=>x.ID==1);

[@yoskar18xd]

im having problems adapting SQL db to the project, i've missed the part where you explained that, pls help!

[@aapkanigam]

Please watch 26 for updating entity after any modification to table or db

[@yoskar18xd]

@@aapkanigam well sorry, I just found out sql is not available, so I don't even have the DB install on visual studio, any alternative?...

[@yoskar18xd]

In Mac I Meant!

[@mohammadfasih7752]

what we should code if we want to display all the emplyees insted of one???

[@aapkanigam]

+Faizan Raza watch part 16

[@mohammadfasih7752]

ok!!

[@aliridhohabsyi1242]

Aisihis i got a problem with "employeeVM.EmployeeId = employee.EmployeeId;" because "An exception of type 'System.NullReferenceException' occurred in Technotips.dll but was not handled in user code." What should i do ??

[@aapkanigam]

+Ali Ridho Habsyi check for null value in model before assigning any property. Ex if (model!=null){// assign values }

[@Mulllll]

got the same problem. the delet of "if (Model!=null)" gives the same error

[@aapkanigam]

+Michali Alex dont delete that .. are you sure you getting data from database? If you are inserting data and you id is primary key not nullable then dont assign any value to it.

[@aapkanigam]

+Michali Alex dont delete that .. are you sure you getting data from database? If you are inserting data and you id is primary key not nullable then dont assign any value to it.

[@Mulllll]

hey ashish. thanks for answering so fast. i will subscribe and share your videos. i am not sure if i get data from database. in the first 4 videos i got data from database. but since i use the entity framework i get the nullreference exception. even if i check if model is not null. could it be that there is no conneciton to my database? but everything looks like in your video. damn since 4 hours i try to solve htis problem.

[@shankarguru1309]

Awesome tutorial for beginners..!!

[@aapkanigam]

Thanks 😊 keep learning and sharing 🙏

[@LuigiZuniga]

Thanks for your Videos!!!

[@aapkanigam]

+Luis Alberto Pino Zuñiga keep learning and sharing

[@crizalyncauilan8094]

where is the database you use in video?

[@aapkanigam]

part 26 will help you

[@DanGerouszaPoisonous]

TY 2k times !!!

[@tejaswininanaware]

Is the TestController an empty controller?

[@aapkanigam]

There is only one method which will return a View

[@saivigneshwaran150]

Thank You

[@someone418]

thanks for reply. C# Function.

[@aapkanigam]

+Priyanka Gupta Yes you can create many method which is returning something. Like string , int , list, class etc .. suppose you want to create add funtion then use public int Sum (int i,int j){ Int c= i+j; return c; } Call this function in any other class .. Example - int result= Sum (5,7);

[@paragkotekar1763]

Nice and Detailed

[@markusmulholland]

Very easy to follow and understand. Thank you sir

[@ayoforyou448]

many thak's mate

[@bijoy_7168]

It is helped me a lot

[@aapkanigam]

Keep learning and sharing thanks

[@navzme]

Thanks for awesome video

[@aapkanigam]

Thanks ..keep learning and sharing

[@csabasomogyi6780]

How can i create database?

[@aapkanigam]

+Csaba Somogyi watch part 26

[@csabasomogyi6780]

I dowloaded the sql server managment studio but i can't know how can i connect to database.

[@aapkanigam]

+Csaba Somogyi watch part 6

[@bobtaylor1577]

I jumped from tutorial 4 to tutorial 6 because of your sql !!!!!!!

[@Anilkumar-pi6gf]

Thanks! Your videos are very helpful. It would be great if you provide code for this series.

[@nguyenhongduong8688]

Thank you so much, This video is very important with me

[@visaboxofficial]

Excatly, This is what i wanted.... An other Guy on KZbin has Also such Wonderful Videos To go On with MVC, but he missed this step, which took my 4 days, and forced me to switch to some other tutorials, which ultimately are your's Now. Stay Blessed !

[@aapkanigam]

+Art Is LIFE is Art Thanks keep learning and sharing

[@n.hartmann5534]

Im guessing the other guy is KudVenkat:)

[@jenasusil6]

Hello sir 1st of all Thank you very much for your beautiful videos..Sir can you please help me to solve this below error. Even after i have changed my control name in route config file i am getting the same error. Server Error in '/' Application. The resource cannot be found. Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly. Requested URL: / Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.36290

[@aapkanigam]

+Susil Jena please check the controller and method name ..and then route. config file . This error comes when either the requested file is missing or incorrect method or controller name being mentioned.

[@jenasusil6]

Technotips - Ashish sir i have updated my controller name and action method name in routeconfig.cs file.but still i am getting same error.

[@aapkanigam]

+Susil Jena There might be problem with your route config file . If you are using attribute routing the Part 38 may be helpful for you to set correct route value .

[@daviddonadze221]

Thank u so much for this detailed Video. u are the best!!!!!!

[@aapkanigam]

+David Donadze Thanks ..keep learning and sharing

[@Infinitesap]

Awsome quality of teaching! Thanks very much :)

[@aapkanigam]

Thanks ..keep learning and sharing

[@hamedkadkhodaie7715]

No ! No ! No ! why are you calling the Database in controller ? You are ruining your MVC Pattern, it's DB

[@aapkanigam]

+Hamed kadkhodaie Hey dear .. I have not explained repository pattern yet .. there will call database from data access layer-> business -> controller -> view

[@aapkanigam]

+Hamed kadkhodaie MVC does not have to do with the architecture you have provided . If I dont use model ,still I can render data to view. YOU can call database directly from controller without having any issue.

[@Anilkumar-pi6gf]

Hamed kadkhodaie Yes you can call the database from controller. At Microsoft official site you will get several example of controller calling database .