/// <summary> ///get information based on different entities and their IDs/// </summary> /// <typeparam name= "T" ></typeparam> /// <param name= "entity" ></param> /// <param name= "ID" >because there are [ID] columns in the table-so there is no need to pass the column name {if your primary key is autoid-then you have to deal with it separately ...}</param> /// <returns></returns> PublicIlist<t> getinfobyid<t> (T entity,intID) {//EF-generated-names are filled out by themselves when generating EF models ↓DBEntities db =Newdbentities (); //Execute SQL statements dynamicallyIlist<t> retlist = db. Database.sqlquery<t> ("SELECT * from"+typeof(T). ToString (). Split ('.')[1] +"WHERE id="+ID). ToList (); returnretlist; }
Just getting Started with EF and LINQ ... Please enlighten ...
Here's how to call the method ... ↓
int 1 ; IList<TableName> query = Getinfobyid (new TableName (), ID);
Get data from a database based on different entities and their IDs