Saturday, 3 August 2013

Executing SQL Query Using LINQ to SQL,Directly Execute SQL Queriesm

 IEnumerable<tbl_LeaderMaster> leader = obj.ExecuteQuery<tbl_LeaderMaster>("select * from tbl_LeaderMaster where leaderid in (select top(6) leaderid from tbl_CommRating order by outof)");

        DataList1.DataSource = leader;
        DataList1.DataBind();

Friday, 2 August 2013

Random rows from Linq to Sql

       Random rand = new Random();
        int toSkip = rand.Next(0, obj.tbl_LeaderMasters.Count());
        var leader = obj.tbl_LeaderMasters.Skip(toSkip).Take(10) ;

   
        DataList1.DataSource = leader;
        DataList1.DataBind();