limit number of rows in EF in mvc

Question

hello sir , i am new beginner in Ef .can u write query syntax for us in .net ? how to limit no of records in ef var commennt1 = (from b in ctx.Blogstatus join c in ctx.CommentTables on b.id equals c.id_blog select new { CommentMsg = c.CommentMsg, CreatedBy = c.CreatedBy, id = b.id }).ToList().Select(y => new CommentTable { CommentMsg = y.CommentMsg, CreatedBy = y.CreatedBy, } ).ToList(); ViewBag.totalcomment3s = commennt1;

Madan Shekar · Answer

// Create one Class like public class Getallcomments { public dynamic CommentMsg {get;set;} public dynamic CreatedBy{get;set;} public dynamic id {get;set;} } // Controller level code var commennt1 = (from b in ctx.Blogstatus join c in ctx.CommentTables on b.id equals c.id_blog select new { CommentMsg = c.CommentMsg, CreatedBy = c.CreatedBy, id = b.id }).ToList().Take(10); List allcomments=new List (); if(commennt1 !=null) { foreach(var i in commennt1 ) { allcomments.add(new {CommentMsg =i.CommentMsg , id=i.id,CreatedBy=i.CreatedBy}); } } return view(allcomments) ; In view level @model List foreach(var i in Model) { @i.CommentMsg } this is how you can do any doubt message me

Puneet Kankar · Answer

var abc = (from st in Context.STopics where st.IsActive && st.StudentID == 123 select new result { name = st.name }); abc = abc.Take(100); abc = abc.ToList();

sonal malhotra · Answer

Server Error in '/' Application. Unable to cast object of type ' d__25`1[ f__AnonymousType6`3[System.String,System.String,System.Int32]]' to type 'System.Collections.Generic.List`1[blog_newone.Models.CommentTable]'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidCastException: Unable to cast object of type ' d__25`1[ f__AnonymousType6`3[System.String,System.String,System.Int32]]' to type 'System.Collections.Generic.List`1[blog_newone.Models.CommentTable]'. Source Error: @foreach (var item1 in (List )ViewBag.totalcomment3s) { @Html.DisplayFor(modelItem => item1.CreatedBy) @Html.DisplayFor(modelItem => item1.CommentMsg) } Line 19: Read More.. Line 20: Line 21: @foreach (var item1 in (List )ViewBag.totalcomment3s) Line 22: { Line 23:

Madan Shekar · Answer

var commennt1 = (from b in ctx.Blogstatus join c in ctx.CommentTables on b.id equals c.id_blog select new { CommentMsg = c.CommentMsg, CreatedBy = c.CreatedBy, id = b.id }).ToList().Take(10); this will works pls check and let me know

sonal malhotra · Answer

hi all, i tried to put both of ur answer. but it shown below error Unable to cast object of type ' d__25`1[blog_newone.Models.CommentTable]' to type 'System.Collections.Generic.List`1[blog_newone.Models.CommentTable]'.

Madan Shekar · Answer

your query updated var commennt1 = (from b in ctx.Blogstatus join c in ctx.CommentTables on b.id equals c.id_blog select new { CommentMsg = c.CommentMsg, CreatedBy = c.CreatedBy, id = b.id }).ToList().Select(y => new CommentTable { CommentMsg = y.CommentMsg, CreatedBy = y.CreatedBy, } ).ToList().Take(10); // from db itself it wil take only 10 rows ViewBag.totalcomment3s = commennt1; any issues ping me

Sanwar Ranwa · Answer

Hello sonal Use this query Take function is use to limit data var limitdata = commennt1 .Take(10);