performance - Entity Framework queries speed -


Recently I started learning the unit framework.

The first question in my mind is this:

When we want to use LINQ to fetch data in the ENF, then every query is like this: 

 Select p in contact with  var a = p. Name;   
 will be converted to SQL commands like this:  
  choose names from contacts   
     
  1.  Every time we are querying, changing it again  
  2.  I've heard that stored procedures are cached in the database, is this event in the LINQ queries in the unit framework?   
     And finally my question is clear?  
      
     
     
     Both linux expression caching are being optimized and which SQL server caches for cache , The only way is to measure the speed and memory consumption of your functionality  
     To see how the SQL is built, you can use it which I have found very good. You can get this information  some  through SQL Profiler, it's just a lot more work.

Comments

Post a Comment