English 中文(简体)
Linq to entity timing problem
原标题:

I created a data model that has some views from my database as entities,when I create a linq statment that has part of this view s entities ,the time processor take to execute the linq statment is very long.. can anyone help?

最佳回答

The solution was to map the view as a is a table in the entity model then the problem is solved

问题回答

this query was working by very short time but before adding the views in the model but after adding views it takes more that 10 minutes to be executed var roles=(from r in db.SystemObjectSet where r.ObjectsTypes.ObjectType.Equals("Role") select r ).ToList();





相关问题
LINQ Training: Native SQL Queries to LINQ

Can anyone point out some good LINQ training resources. Mostly interested in getting some developers that are very skilled with SQL up to speed using Lambda and LINQ queries. They are struggling with ...

How can i write Linq2Entities Query with inner joins

How can I get data from these related entities. I want to get these columns only: Term.Name , related Concept_Term.Weight, related Concept.Id I wrote the SQL but I don t want to use select t....

Linq to enties, insert foreign keys

I am using the ADO entity framework for the first time and am not sure of the best way of inserting db recored that contain foreign keys. this is the code that i am using, I would appreciate any ...

Linq to entity timing problem

I created a data model that has some views from my database as entities,when I create a linq statment that has part of this view s entities ,the time processor take to execute the linq statment is ...

热门标签