For Beginers on Entity Framework (EF.)

Enitity Framework is another way to ad database to your  project.Here can add a model in the solution so that we can link the database. Here we don't need to write the SQL connection again and again. this also uses LINQ. that is the  another way to insert or fetch the data from the database..
firstly right click on the solution in the solution explorer window. then we can add ADO entity model from the "Data" section.then give the server name and select your database then select the table you want to add.
NOTE:  primary key is required in  every table for EF to work on that specific table .

Comments

Post a Comment

Popular posts from this blog

How to use lamda expression for updating using LINQ

This is small example showing how we use lamda expression in the programming section , Generally we use lamda expression when working wiht LINQ , or the classs of list type where need to get the data based on any where clause. public Boolean Update(string id) { int flag = 0; string str = DateTime.Now.Day + "-" + DateTime.Now.Month + "-" + DateTime.Now.Year; foreach (var c in obj.Task_Details.Where(x => x.task_no == id)) { c.task_date = str; flag = 1; c.status = "Complete"; } obj.SaveChanges(); if (flag == 1) { return true; } else { return false; } }
Read more

using session for login and logout in asp.net

firstly open the "Global.aspx". then create a function there  protected void Application_Start() { //we give the name of the session  here and declare it null ..username is the name of the session //we can change it according to our needs Sesssion["username"]=""; } now we can create the function where we are login as function boolean login( string username, string password) {   // firstly we match the login details from the database. if(username == logincredintialfromdb && password ==logincredintialfromdb ) { // the values are matched here so are assiging the value to the session variable Session["username"]= username ; return true; } else { return false; } }
Read more

How to post data in MVC using form collection for Beginners.

Here we can simply put the data into the form tag and give each component an name .We are creating a login form using the MVC Architecture. <form method="post" action="Name_of_the_function> <input type="text" name=username id=username> <input type="password" name =pass id=pass> <input id=submit type="submit"> on controller [httppost] public ActionResult Name_of_the_function(formcollection form) { string str=form["username"]; string str1= form["pass"]; }
Read more