Daily Global Updates

Friday, 16 June 2017

Entity Framework

Install Nuget Package from Visual Studio ( Entity Framework)
Add EntityFramework.dll
and EntityFramewok.SqlServer.dll into references.

1) If you want to select rows from Table :

using (dbEntities db = new dbEntities())
{
var result = db.Customers.Select(x => x).OrderBy(x => x.Customer_ID).ToList();

var result = db.QTMS_JohnToGo_Equipment.Where(x => x.Is_Deleted == false).Select(x => x).OrderBy(x => x.Equipment_ID).ToList();

var lst = db.QTMS_VipToGo_Equipment.Where(x => x.Is_Deleted == false && x.Equipment_ID == id).Select(x => x.Equipment_Description).ToList();

if (lst != null && lst.Count() > 0)
return JsonConvert.SerializeObject(lst);
}

//jquery code
alert("My age is : " + Bresponse[0].Customer_Age);

//Code Behind for Adding / Update records in Entity Framework.
[WebMethod]
public static string GetCustomerData(string entity)
{
using (ViftechEntities db = new ViftechEntities())
{
JavaScriptSerializer js = new JavaScriptSerializer();
Customer defaultdata = (Customer)js.Deserialize(entity, typeof(Customer));

Customer obj;
//update
if (defaultdata.Customer_ID > 0)
{
// obj = new Customer();
obj = db.Customers.Where(x => x.Customer_ID == defaultdata.Customer_ID).FirstOrDefault();
if (obj != null)
{
obj.Customer_Age = 12;
obj.Customer_Name = "Naya Naam";
db.SaveChanges();
}
}

//add new
else
{
obj = new Customer();
obj.Customer_Name = "Salman";
obj.Customer_Age = 29;

db.Customers.Add(obj);
db.SaveChanges();
}

var result = db.Customers.Select(x => x).OrderBy(x => x.Customer_ID).ToList();
return JsonConvert.SerializeObject(result);
}
}