How to use SQL statements with LINQ

Here is the answer. You can use it like this.

 

String strSQL="select * from player_Master where player_Id={0}";

 

IEnumerable<Player_Master> PlayerList =  context11.ExecuteQuery<Player_Master>(strSQL, "10023");

Player_Master Paly11 = PlayertList.Single<Player_Master>();

Response.Write(Play11.PlayerName);

 

 

This is just a simpel