Dot Net Rules : LINQ to Entitieshttp://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/tags/LINQ+to+Entities/default.aspxΕτικέτες: LINQ to EntitieselCommunityServer 2.1 SP3 (Build: 20423.1)Using Second Level Cache in Entity Framework 6.1 applicationshttp://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2015/06/28/using-second-level-cache-in-entity-framework-6-1-applications.aspxSat, 27 Jun 2015 23:00:00 GMT2622095e-976c-431a-859e-16783ec7ecd7:77117nikolaosk0http://www.dotnetzone.gr/cs/blogs/dotnetrules/comments/77117.aspxhttp://www.dotnetzone.gr/cs/blogs/dotnetrules/commentrss.aspx?PostID=77117In this post I am going to provide you with a hands-on example on how to use second level caching with Entity Framework 6.0 version. Second Level Caching is one of the features that is not present out-of-the-box in Entity Framework. Second level cache is a query cache. The results of SQL commands are stored in the cache, so that the same SQL commands retrieve their data from the Cache rather than executing the query again against the underlying provider. This can have a performance boost for your application and results in less activity against your database, at the cost of increased memory. There is currently a project in codeplex, EntityFramework.Cache that enables us caching of query results for EF 6.1 applications. Entity Framework is an object-relational mapping (ORM) framework for the .NET Framework.EF addresses the problem of Object-relational impedance mismatch. I will not be talking about that mismatch because it is well documented in many sites on the Internet. Through that framework we can program against...(<a href="http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2015/06/28/using-second-level-cache-in-entity-framework-6-1-applications.aspx">read more</a>)<img src="http://www.dotnetzone.gr/cs/aggbug.aspx?PostID=77117" width="1" height="1">Entity frameworkcachingLINQ to EntitiesEntity Framework 6.0Database Command Logging & Profiling in Entity Framework 6.0http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2015/06/16/database-command-logging-amp-profiling-in-entity-framework-6-0.aspxTue, 16 Jun 2015 19:56:00 GMT2622095e-976c-431a-859e-16783ec7ecd7:77098nikolaosk0http://www.dotnetzone.gr/cs/blogs/dotnetrules/comments/77098.aspxhttp://www.dotnetzone.gr/cs/blogs/dotnetrules/commentrss.aspx?PostID=77098In this post I am going to provide you with a hands-on example on how to log commands &amp; queries sent to the database by Entity Framework 6.0. You can use the fantastic Entity Framework third party profiler by Hibernating Rhinos if you want. You can find a similar post here . Entity Framework is an object-relational mapping (ORM) framework for the .NET Framework.EF addresses the problem of Object-relational impedance mismatch. I will not be talking about that mismatch because it is well documented in many sites on the Internet. Through that framework we can program against a conceptual application model instead of programming directly against a relational schema-model. By doing so we can decrease the amount of code we do write to access a data storage and thus decrease maintenance time. You can find many posts regarding Entity Framework in this blog. 1) Create an empty ASP.Net Application (Web Forms Application) and give it the name EFLogging. I am using Visual Studio 2013 Ultimate edition. 2) Add a new web...(<a href="http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2015/06/16/database-command-logging-amp-profiling-in-entity-framework-6-0.aspx">read more</a>)<img src="http://www.dotnetzone.gr/cs/aggbug.aspx?PostID=77098" width="1" height="1">Entity frameworkLINQ to EntitiesProfilingEntity Framework 6.0Using the Code First approach when building ASP.Net applications with Entity Framework http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2011/08/08/using-the-code-first-approach-when-building-asp-net-applications-with-entity-framework.aspxMon, 08 Aug 2011 19:44:00 GMT2622095e-976c-431a-859e-16783ec7ecd7:66791nikolaosk0http://www.dotnetzone.gr/cs/blogs/dotnetrules/comments/66791.aspxhttp://www.dotnetzone.gr/cs/blogs/dotnetrules/commentrss.aspx?PostID=66791In this post I would like to show you a hands-on example on how to use the Code First approach when building data-centric ASP.Net applications with EF. Obviously I cannot go into much detail on what EF is and what it does. I will give again a short introduction...( read more )...(<a href="http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2011/08/08/using-the-code-first-approach-when-building-asp-net-applications-with-entity-framework.aspx">read more</a>)<img src="http://www.dotnetzone.gr/cs/aggbug.aspx?PostID=66791" width="1" height="1">asp.netC#Visual Studio 2010Entity frameworkdata access layerLINQ to EntitiesdatabindingCode FirstEnhancing performance in Entity Framework applications by precompiling LINQ to Entities querieshttp://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2011/03/10/enhancing-performance-in-entity-framework-applications-by-precompiling-linq-to-entities-queries.aspxThu, 10 Mar 2011 13:16:00 GMT2622095e-976c-431a-859e-16783ec7ecd7:64116nikolaosk0http://www.dotnetzone.gr/cs/blogs/dotnetrules/comments/64116.aspxhttp://www.dotnetzone.gr/cs/blogs/dotnetrules/commentrss.aspx?PostID=64116This is going to be the tenth post of a series of posts regarding ASP.Net and the Entity Framework and how we can use Entity Framework to access our datastore. You can find the first one here , the second one here , the third one here , the fourth one...( read more )...(<a href="http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2011/03/10/enhancing-performance-in-entity-framework-applications-by-precompiling-linq-to-entities-queries.aspx">read more</a>)<img src="http://www.dotnetzone.gr/cs/aggbug.aspx?PostID=64116" width="1" height="1">asp.netc# 3.0C#Visual Studio 2010ASP.NET 4.0Entity frameworkLINQ to EntitiesperformanceprecompilationLazy Loading,Eager Loading,Explicit Loading in Entity Framework 4http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2011/03/10/lazy-loading-eager-loading-explicit-loading-in-entity-framework-4.aspxThu, 10 Mar 2011 00:41:00 GMT2622095e-976c-431a-859e-16783ec7ecd7:64084nikolaosk0http://www.dotnetzone.gr/cs/blogs/dotnetrules/comments/64084.aspxhttp://www.dotnetzone.gr/cs/blogs/dotnetrules/commentrss.aspx?PostID=64084This is going to be the ninth post of a series of posts regarding ASP.Net and the Entity Framework and how we can use Entity Framework to access our datastore. You can find the first one here , the second one here , the third one here , the fourth one...( read more )...(<a href="http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2011/03/10/lazy-loading-eager-loading-explicit-loading-in-entity-framework-4.aspx">read more</a>)<img src="http://www.dotnetzone.gr/cs/aggbug.aspx?PostID=64084" width="1" height="1">asp.netc# 3.0C#Visual Studio 2010ASP.NET 4.0Entity frameworklazy loadingLINQ to Entitieseager loadingexplicit loadingData binding in an ASP.Net application with Entity Frameworkhttp://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2011/03/08/data-binding-in-an-asp-net-application-with-entity-framework.aspxTue, 08 Mar 2011 17:48:00 GMT2622095e-976c-431a-859e-16783ec7ecd7:64056nikolaosk0http://www.dotnetzone.gr/cs/blogs/dotnetrules/comments/64056.aspxhttp://www.dotnetzone.gr/cs/blogs/dotnetrules/commentrss.aspx?PostID=64056This is going to be the eighth post of a series of posts regarding ASP.Net and the Entity Framework and how we can use Entity Framework to access our datastore. You can find the first one here , the second one here , the third one here , the fourth one...( read more )...(<a href="http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2011/03/08/data-binding-in-an-asp-net-application-with-entity-framework.aspx">read more</a>)<img src="http://www.dotnetzone.gr/cs/aggbug.aspx?PostID=64056" width="1" height="1">asp.netc# 3.0C#Visual Studio 2010ASP.NET 4.0Entity frameworkLINQ to EntitiesdatabindingIdentity Map Pattern and the Entity Frameworkhttp://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2011/03/07/identity-map-pattern-and-the-entity-framework.aspxMon, 07 Mar 2011 21:43:00 GMT2622095e-976c-431a-859e-16783ec7ecd7:64022nikolaosk0http://www.dotnetzone.gr/cs/blogs/dotnetrules/comments/64022.aspxhttp://www.dotnetzone.gr/cs/blogs/dotnetrules/commentrss.aspx?PostID=64022This is going to be the seventh post of a series of posts regarding ASP.Net and the Entity Framework and how we can use Entity Framework to access our datastore. You can find the first one here , the second one here and the third one here , the fourth...( read more )...(<a href="http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2011/03/07/identity-map-pattern-and-the-entity-framework.aspx">read more</a>)<img src="http://www.dotnetzone.gr/cs/aggbug.aspx?PostID=64022" width="1" height="1">asp.netc# 3.0C#Visual Studio 2010ASP.NET 4.0Entity frameworkLINQ to EntitiesObject CacheIdentity Map PatternEntity Framework and Plain Old CLR Objects in an ASP.Net applicationhttp://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2011/03/06/entity-framework-and-plain-old-clr-objects-in-an-asp-net-application.aspxSun, 06 Mar 2011 19:59:00 GMT2622095e-976c-431a-859e-16783ec7ecd7:63993nikolaosk0http://www.dotnetzone.gr/cs/blogs/dotnetrules/comments/63993.aspxhttp://www.dotnetzone.gr/cs/blogs/dotnetrules/commentrss.aspx?PostID=63993This is going to be the sixth post of a series of posts regarding ASP.Net and the Entity Framework and how we can use Entity Framework to access our datastore. You can find the first one here , the second one here and the third one here , the fourth one...( read more )...(<a href="http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2011/03/06/entity-framework-and-plain-old-clr-objects-in-an-asp-net-application.aspx">read more</a>)<img src="http://www.dotnetzone.gr/cs/aggbug.aspx?PostID=63993" width="1" height="1">asp.netc# 3.0Visual Studio 2010ASP.NET 4.0Entity frameworkLINQ to EntitiesPOCOS