Interesting Findings - Entity Framework

Performance Considerations
http://msdn.microsoft.com/en-us/data/hh949853.aspx

Notracking option
If you don't want the context to track some entities you can use this option. But make sure to use it in correct situations. Otherwise you'll end up having bad performance.

Often, Entity Framework generates nested sql queries. This is the easiest way to build query logically from the expression tree.

Entity Framework 7
http://blogs.msdn.com/b/adonet/archive/2014/10/21/ef7-what-does-code-first-only-really-mean.aspx

Select top (2) in Entity Framework
http://geekswithblogs.net/JuansAndZeros/archive/2013/04/18/why-entity-framework-profiler-is-showing-select-top-2-queries.aspx
http://stackoverflow.com/questions/11839123/why-singleordefault-result-top2-in-sql
http://stackoverflow.com/questions/7822877/why-does-the-entity-frameworks-dbcontext-find-generate-a-query-with-select-to

Read More

What you need to know about performance in Entity Framework

http://msdn.microsoft.com/en-us/data/hh949853.aspx 

Mapping Views
Mapping views are set of SQL statements that represents the database in an abstract way, which are also part of the metadata.
link1, link2

Query execution
Deferred vs. Immediate execution
Client side execution of LINQ queries
Query and mapping complexity
Mapping complexity
Query complexity
Relationships
Query paths
Saving changes
Distributed Transactions

Strategies for Performance improvement

Pre-generate views
Consider using NoTracking merge option for queries
Return the correct amount of data
Limit the scope of ObjectContext
Consider opening db connection manually.

Extra

• In EF its best to understand how query execution happens 
• Data Source is the one which provides connection pooling facility. Not the Entity Framework. The .NET provider for SQL Server provides support for Connection Pooling
• In previous versions of EF (before 6) there was a performance problem when using Contains. This has been fixed now.
• 
  

https://msdn.microsoft.com/en-us/data/hh949853.aspx
http://www.asp.net/web-forms/overview/older-versions-getting-started/continuing-with-ef/maximizing-performance-with-the-entity-framework-in-an-asp-net-web-application

http://msdn.microsoft.com/en-us/library/8xx3tyca(v=vs.110).aspx

http://stackoverflow.com/questions/3653009/entity-framework-and-connection-pooling?rq=1

http://www.asp.net/whitepapers/aspnet-data-access-content-map#gettingstarted

http://msdn.microsoft.com/en-us/library/cc853327.aspx

Read More

All about JavaScript

Data Types

Functions

Hoisting

This 

Prototyping

Closures


Stuff you need to know in JavaScript


Interesting Findings

Read More

Stuff you need to know about JavaScript

JavaScript has lot of concepts around it. There are things that you might miss out. Lets see some of them.

• In JavaScript there are some variables starting as __ (__defineGetter, __defineSetter, __proto__). These are variables defined by the browser and are not defined by ECMAScript #convention (link2)
•  Best practice to define libraries is to define one global variable (google, jquery) and define all your methods/variables within the scope of that object
• JavaScript curry
• Adding custom headers to JQuery AJAX request
• Browser closing events
• http://stackoverflow.com/questions/1119289/how-to-show-the-are-you-sure-you-want-to-navigate-away-from-this-page-when-ch
• http://stackoverflow.com/questions/2076299/how-to-close-current-tab-in-a-browser-window
• http://stackoverflow.com/questions/4869613/solutions-for-distributing-html5-applications-as-desktop-applications

Scope and Context in JavaScript

https://www.google.lk/search?q=scope+vs+context+javascript

http://ryanmorr.com/understanding-scope-and-context-in-javascript/

http://stackoverflow.com/questions/2628672/what-should-every-javascript-programmer-know?rq=1

Read More