Creating a Linq statement to create objects

Question

If I created a Linq statement as shown below, it works fine.

var Jobs = from a in ctx.MyExport
           select new
           {
               FileName = a.FilePath,
               JobId = a.ID,
           };

If I want to use a class rather than an anonymous type I get the following error "Cannot convert lambda expression to type 'string' because it is not a delegate type".

Here is the code I want to work:

var Jobs = from a in ctx.MyExport
           select new MyClass
           {
               FileName = a.FilePath,
               JobId = a.ID,
           };

And here is the class:

public class MyClass
{
    public string FileName { get; set; }
    public Guid JobId { get; set; }
}

Can anyone tell me what I am doing wrong and how to fix it?

I fixed the problem by replacing "var" with IEnumerable<MyClass> — Retrocoder
– Retrocoder, Commented Jan 28, 2010 at 12:06

Jacob · Accepted Answer · 2010-02-01 20:09:43Z

1

The above code is correct , you are getting error message because of the code you didn't showed us.

You are trying to assign unmaterialized query to string variable which will result in error. Changing type to IEnumerable will materialize the query immediately whether you use it or not it will be taken out from data base.So that solution is not recomended.

The answer would be to materialize the query before usage , I assume that you are doing foreach on this collection ,so Jobs.AsEnumerable() or Jobs.ToList() (depending on what you want to do with it) is what you should be doing.

answered Feb 1, 2010 at 20:09

Jacob

9142 gold badges11 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating a Linq statement to create objects

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related