Archive
Is it possible to disable forms authentication for specific sub directories of an application?
Yes we can disable forms authentications for specific sub directory using below code in config files
<location path="Folder" allowOverride=”false”>
<system.web>
<authorization>
<allow users="*" />
</authorization>
</system.web>
</location>
Hope this help !
Tips to improve Entity Framework Performance
LINQ to Entity is a great ORM for querying and managing database. It offers a lot of things, so it is mandatory to know about performance of it. These are right up to a certain point as LINQ comes with its own penalties. There are some tips and tricks that we should keep in mind while designing and query database using entity framework ORM. Here is a list of some tips that I would like to share with you.
-
Avoid to put all the DB Objects into One Single Entity Model
Entity Model specifies a single unit of work, not all our database. If we have many database objects that are not connected to one another or these(log tables, objects used by batch processes etc.) are not used at all. Hence these objects are consuming space in the memory and cause performance degrades. So try to make separate entity models of related database objects.
-
Disable change tracking for entity if not needed
Whenever you retrieve the data only for reading purpose, not for modification then there is no need of object tracking. So disable object tracking by using MergeOption as below:
NorthwindDataContext context = new NorthwindDataContext();
context.tblCities.MergeOption = MergeOption.NoTracking;
This option allows us to turn off the object cache and unnecessary identity management of the objects.
-
Use Pre-Generating Views to reduce response time for first request
When the object of ObjectContext is created first time in the application, the entity framework creates a set of classes that is required to access the database. This set of classes is called view and if your data model is large then creating the view may delay the web application response to the first request for a page. We can reduce this response time by creating view at compile time by using T4 template or EdmGen.exe command-line tool.
-
Avoid fetching all the fields if not required
Avoid fetching not required fields from the database. Suppose I have table of Customer with 20 fields and I am interested only in three fields – CustomerID, Name, Address then fetch only these three fields instead of fetching all the fields of the Customer table.
//Bad Practice
var customer =
(from cust in dataContext.Customers
select cust).ToList();
//Good Practice
var customerLite =
(from cust in dataContext.Customers
select new {
customer. CustomerID,
customer.Name,
customer.Address
}). ToList ();
-
Choose appropriate Collection for data manipulation
In linq we have Var, IEnumerable, IQueryable, IList type collection for data manipulation. Each collection has its importance and performance impact on the query, so beware of using all these collection for data manipulation.
-
Use Compiled Query wherever needed
Make a query to compiled query if it is frequently used to fetch records from the database. This query is slow in first time but after that it boost the performance significantly. We use Compile method of CompiledQuery class for making compiled query.
Suppose you required to retrieve customers details again and again based on city then make this query to compiled query like as
// create the entity object
NorthwindEntities mobjentity = new NorthwindEntities();
//Simple Query
IQueryable lstCus = from customer in mobjentity.tblCustomers
where customer.City == “Delhi”
select customer;
//Compiled Query
Func> compiledQuery
= CompiledQuery.Compile>(
(ctx, city) =>from customer in ctx.Customers
where customer.City == city
select customer);
In above query we are passing the string parameter city for filtering the records.
-
Retrieve only required number of records
When we are binding data to grid or doing paging, retrieve only required no of records to improve performance. This can achieved by using Take,While and Skip methods.
// create the entity object
NorthwindEntities mobjentity = new NorthwindEntities();
int pageSize=10,startingPageIndex=2;
List lstCus = mobjentity.tblCustomers.Take(pageSize)
.Skip(startingPageIndex * pageSize)
.ToList();
-
Avoid using Contains
In LINQ, we use contains method for checking existence. It is converted to “WHERE IN” in SQL which cause performance degrades.
-
Avoid using Views
Views degrade the LINQ query performance costly. These are slow in performance and impact the performance greatly. So avoid using views in LINQ to Entities.
-
Debug and Optimize LINQ Query
If you want to debug and optimize your query then LINQ Pad is a great tool for this purpose. I am a big fan of LINQ Pad. It is very useful for query construction, debugging and optimization.
IQueryable lstCus = from customer in mobjentity.tblCustomers
where customer.City == “Delhi”
select customer;
lstCus.Dump();
Dump method of LINQ Pad give the result of above query in the result window.
Understanding asp.net MVC (Model View Controller) architecture
This article is intended to provide basic concept and fundamentals of asp.net MVC (Model View Controller) architecture workflow for beginners.
Introduction:
“M” “V” “C” stands for “MODEL” “VIEW” “CONTROLLER” , asp.net MVC is an architecture to develop asp.net web applications in a different manner than the traditional asp.net web development , web applications developed with asp.net MVC is even more SEO (Search Engine Friendly ) friendly.
Developing asp.net MVC application requires Microsoft .net framework 3.5 or higher.
MVC interaction with browser:
Like a normal web server interaction, MVC application also accept request and respond web browser same way.
Inside MVC architecture:
Whole asp.net MVC architecture is based on Microsoft .net framework 3.5 and in addition uses LINQ to SQL Server.
What is a Model?
- MVC model is basically a C# or VB.net class
- A model is accessible by both controller and view
- A model can be used to pass data from Controller to view.
- A view can use model to display data in page.
What is a View?
- View is an ASPX page without having a code behind file
- All page specific HTML generation and formatting can be done inside view
- One can use Inline code (server tags ) to develop dynamic pages
- A request to view (ASPX page) can be made only from a controller’s action method
What is a Controller?
- Controller is basically a C# or VB.net class which inherits system.mvc.controller
- Controller is a heart of whole MVC architecture
- Inside Controller’s class action methods can be implemented which is responsible for responding to browser OR calling view’s.
- Controller can access and use model class to pass data to view’s
- Controller uses ViewData to pass any data to view
MVC file structure & file naming standards
MVC uses a standard directory structure and file naming standards which is very important part of MVC application development.
Inside the ROOT directory of the application there must be 3 directories each for model, view and Controller.
Apart from 3 directories there must have a Global.asax file in root folder. And a web.config like a traditional asp.net application.
-
Root [directory]
-
Controller [directory]
- Controller CS files
- Controller CS files
-
Models [directory]
- Model CS files
- Model CS files
-
Views [directory]
- View CS files
- View CS files
- Global.asax
- Web.config
-
Asp.net MVC Execution life cycle
Here is how MVC architecture executes the requests to browser and objects interactions with each other.
A step by step process is explained below: [Refer figure as given below]
Step 1: Browser request
Browser request happens with a specific URL. Let’s assume that user entering URL like: [xyz.com]/home/index/
Step 2: Job of Global.asax – MVC routing
The specified URL will first get parsed via application_start() method inside Global.asax file. From the requested URL it will parse the Controller, Action and ID.
So for [xyz.com]/home/index/:
Controller = home
Action = index()
ID = empty — we have not specified ID in [xyz.com]/home/index/, so it will consider as empty string
Step 3: Controller and Action methods
MVC now find the home controller class in controller directory. A controller class contains different action methods,
There can be more than one action method, but MVC will only invokes the action method which is been parsed from the URL, its index() in our case.
So something like: homeController.index() will happen inside MVC controller class.
Invoking action method can return plain text string OR rendered HTML by using view.
Step 4: Call to View (ASPX page)
Invoking view will return view() . a call to view will access the particular ASPX page inside the view directory and generate the rendered HTML from the ASPX and will respond back to the browser.
In our case controller was home and action was index(). So calling view() will return a rendered HTML from the ASPX page located at /views/home/index.aspx.
This is it, the whole process ends here. So this is how MVC architecture works.
Comments