limit number of rows in EF in mvc

sonal malhotra

7y4.7kLearn iOS Programming

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;

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Madan Shekar7y ago
Accepted 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
0
Puneet Kankar7y ago
1. var abc = (from st in Context.STopics
2. where st.IsActive && st.StudentID == 123
3. select new result
4. {
5. name = st.name
6. });
8. abc = abc.Take(100);
9. abc = abc.ToList();
0

sonal malhotra7y ago

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 Shekar7y ago

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 malhotra7y ago

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 Shekar7y ago

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 Ranwa7y ago

Hello sonal

Use this query Take function is use to limit data

var limitdata = commennt1 .Take(10);