Explicit construction of entity type

Question

I have a DataModel that contains a Hour table and a HourService that contains the pregenerated CRUD methods.

I have modified the GetHours() to this:

public IQueryable GetHours()
{
	return from hours in this.Context.Hours
		   select new Hour()
		   {
			   HourID = hours.HourID
		   };
}

The reason why I construct a new Hour and set the properties manually is that I have some custom properties defined in a shared.cs file that I'm going to set manually.

This code compiles fine but in runtime I get the following error:

"Explicit construction of entity type 'DataModel.Hour' in query is not allowed."

Any help is appreciated!

Answer 1

I have tried to instantiate and return an other type of entity that is not part of the DataModel - that works just fine.

Could it be a Linq to Sql problem?

Answer 2

Hi,

There are discusstion about exception like that at post.

Answer 3

Try using func<T,TResult>:

Func<Hours, Hours> make =

h => new Hours { HourID= h.HourID };

return from h in this.Context.Hours

select make(h);

 Hope this can help

Jeremy

Answer 4

hi

jcottino Thank you Worked like a Charm..

Regards

Saneesh-B