C # EF Foundation operations

usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingSystem.Reflection;namespaceMCO. ef{ Public classTest {//Instantiation ContextConnectionsql connection =NewConnectionsql (); //Increase         Public intDataadd () {User User=NewUser () {UserName="Lu Liu", Usersex=true            }; Connection.            User.add (user); returnconnection.        SaveChanges (); }        //Delete         Public intDelete () {List<User> User = connection. user.where<user> (U = u.userid >2). Tolist<user>(); foreach(User uinchuser) {connection.            User.remove (U); }            returnconnection.        SaveChanges (); }        //Modify         Public intUpdate () {List<User> User = connection. user.where<user> (U = u.usersex = =true). Tolist<user>(); foreach(User uinchuser) {U.usersex=false; }            returnconnection.        SaveChanges (); }        //Enquiry        Private voiduserlist () {IQueryable userlist= connection. user.where<user> (U = u.userid >1); //reflection gets all the property values and property names of the entity classPropertyinfo[] attribute =typeof(User).            GetProperties (); //calling the Listtojson methodConsole.Write (Listtojson (attribute, userlist)); }        //reflection stitching into JSON        Private stringListtojson (propertyinfo[] attribute, IQueryable dataList) {StringBuilder Strjson=NewStringBuilder ( the); foreach(varDatainchdataList) {Strjson.append ("{");  for(inti =0; I < attribute. Length; i++)                {                    //Get property names and property values (by reflection)Strjson.appendformat ("\ "{0}\": \ "{1}\",", Attribute[i]. Name, Attribute[i].                GetValue (data)); } strjson.remove (Strjson.length-1,1); Strjson.append ("},"); } strjson.remove (Strjson.length-1,1); returnstrjson.tostring (); }    }}

C # EF Foundation operations