Posts

Showing posts with the label Entity Framework

Open .NET Discussion in Jubli Park Jamshedpur on 05/04/2015 Executed

Image
So this was another good time discussing about .NET with developers down the tree in Jubli Park, Jamshedpur.
Post a Comment
Read More »

Logging Database Operations in Entity Framework 6 - EF6 New Feature

Image
In this blog post you will learn a new feature ‘Logging Database Operations’ introduced with Entity Framework 6. This features works for models created with Code First or the EF Designer.
1 comment
Read More »

Customizing User's Profile to add new fields in brand new database table

Image
In this post you will learn how to customize User’s Profile and add new fields/properties/columns (FirstName, LastName and EmailID) in a brand new table with ASP.NET Identity System.
13 comments
Read More »

ASP.NET Identity System in Visual Studio 2013 - New Feature

Image
In this post you will learn about a very new enhancement in ASP.NET Framework technologies (MVC, Web Forms, Web Pages, Web API and SignalR) known as ‘ASP.NET Identity System’ with the release of Visual Studio 2013. This enhancement well defines the meaning of ‘One ASP.NET’, because this can be used with all ASP.NET Framework technologies more easily than before.
2 comments
Read More »

Custom Code First Conventions - EF 6 New Feature

Image
In this blog post you will learn a new feature ‘Custom Code First Conventions’ introduced with Entity Framework 6. This is 'Code First' only improvement. EF 6 comes with number of cool new features and improvements, so I decided to write blog posts and cover some of the new features.
7 comments
Read More »

Entity Framework 6: New Features

In this blog post you will see the list of cool things available with Entity Framework 6. Entity Framework is Microsoft's recommended data access technology for new applications. EF team recently announced the release of EF6 and it is now available for download on NuGet . EF6 comes with number of features and performance improvements, I have listed some of them below and I will cover most of the cool things of EF6 in coming blog posts.
1 comment
Read More »

Scaffold your ASP.NET MVC project with the MvcScaffolding package: Video

Image
In this video you will learn how to scaffold the CRUD/Controller/DbContext using MvcScaffolding package developed by Scott Hanselman and Steve Sanderson.
Post a Comment
Read More »

What is Eager Loading and what is Lazy Loading and what is N+1 Problem in Entity Framework

Image
In this post you will learn what Eager Loading is and what Lazy Loading is and how this works in the application, and how you can take its advantages.
4 comments
Read More »

I Am Now The Published Author of Instant Razor View Engine How-To

Image
I am happy to announce the release of my book ‘ Instant Razor View Engine How-To ’, published by PACKT; and now available at Amazon for purchase. Click on the image to enlarge. Amazon: http://www.amazon.com/dp/1849696306/?tag=packtpubli-20 Packt Publication: http://www.packtpub.com/razor-view-engine/book Like us on Facebook here: https://www.facebook.com/RazorViewEngine
10 comments
Read More »

Example on View to Controller (HttpPost) & warn on duplicate entry & delete duplicates in MVC

Image
This is a quick response post to the blog reader ‘V Patel’ who asked this question yesterday. Here is the question:
5 comments
Read More »

Filter Records in MVC

Image
In this quick post you will learn various ways to filter records in MVC. Before starting let’s have a quick look at a controller and view page that I will use in this article. I will be using the SQL Server Northwind sample database in this article, you can download it from the Microsoft website and set up the same project to explore it.
1 comment
Read More »

Html Helper for Image (@Html.Image): Developing Extension in MVC

Image
Today I worked on a project where I required to display image on the web page. As you know there is not a Html Helper for Images yet. Look at the screen, we can’t see an image here.
7 comments
Read More »

What happens when database doesn't match conventions / using OnModelCreating() feature?

Image
This is just basic article and I’m not going to say anything new here but I will say things in my way.  The very well-known question newbies ask about MVC and Entity Framework is, how does a conceptual database model target the names?
Post a Comment
Read More »

MVC Bind Attribute like [Bind(Exclude = "Name")] or [Bind(Include = "Address, Payment, EmailID")]

Image
When we have an ASP.NET MVC View that accepts user input and posts those inputs to a server we have the option to use the built-in Model-binding features to provide more control and security, we can restrict the properties that are allowed to be bound automatically.
2 comments
Read More »

The name 'Scripts' does not exist in the current context

Image
There is a very small bug in the MVC 4 Empty Template that can be seen when you create a new MVC 4 Application with an "Empty" template and start adding views for CRUD operations (using scaffolding). And when you run the application and try to navigate (to  http://localhost:port/controller/Create  or  http://localhost:port/controller/Edit ) in "Edit.cshtml" and "Create.cshtml" views, you get the following error:
Post a Comment
Read More »

Entity Framework Console Applications with SQL Server Compact

Image
Microsoft SQL Server Compact Edition is an embedded database system that allows us to integrate it in our Web, Desktop and Mobile applications.
4 comments
Read More »

Entity Framework's Database Seed Method

Image
The Entity Framework can automatically create/update/drop databases when the application runs. We can specify that, this should be done every time application runs or only when the model is out of sync with the existing database or in other word it runs whenever model changes. You spent time to insert records in database and when you made any changes in model, Entity Framework deletes your database as well as records.
4 comments
Read More »

Mapping Table-Valued Functions (TVFs) using Entity Framework Database First

Image
Entity Framework 5 brings number of improvements and Mapping Table-Valued Functions (TVFs) Support is one of them.
2 comments
Read More »

Spatial Data Type Support in Entity Framework 5

Image
Entity Framework 5 brings number of improvements and Spatial Data Type Support is one of them.
Post a Comment
Read More »

Playing with Entity Framework's Code First Database Migration

Image
In this video you will learn how to use Entity Framework's Code First Database Migration. I'll create simple console application and will add 'Student' model and then a DbContext in the project.
1 comment
Read More »

Popular posts from this blog

Migrating database from ASP.NET Identity to ASP.NET Core Identity

Image
As you know ASP.NET Core Identity (table structure) is different from what we had earlier in ASP.NET Identity. Actually the identity system which we have today with .NET Core is very mature and continuously evolved be it ASP.NET Membership, ASP.NET Identity 1, ASP.NET Identity 2 and now ASP.NET Core Identity. Recently I had to migrate few application to ASP.NET Core and similar its identity database. Because the table schema is changed, i had to re-think and create migration script which I would like to share with you today. It is very simple and easy, just three step and I had everything ready: STEP 1 : Change name of existing tables STEP 2 : Create ASP.NET Core Identity tables STEP 3 : Migrate data from old tables (ASP.NET Identity) to new tables (ASP.NET Core Identity) Script:  https://gist.github.com/itorian/c699e8534b392a6c726ec66c48100072 You should also watch my video, where I demoed migration.
Read More »

Customize User's Profile in ASP.NET Identity System

Image
Note: You should read this post instead, I found below walkthrough will not work on ASP.NET Identity 2. I will re-work on this post soon. In this post you will learn how to customize User’s Profile and add some more fields like FirstName, LastName, EmailID etc with ASP.NET Identity System. In my last post I listed some of the great new features introduced with Identity system .
Read More »