Posts

Showing posts from September, 2012

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.

Enum Support (EF Designer) in Entity Framework 5

Image
Entity Framework 5 brings number of improvements and Enum Support in EF Designer or Code First is one of them. In this post you will learn it by creating a simple console application then will add EF Designer and will sketch the Model on designer surface. Please note, EF Designer can also be used with the Database First workflow to map to an existing database.

Enum Support (Code First) in Entity Framework 5

Image
Entity Framework 5 brings number of improvements and Enum Support in Code First is one of them.

Normal LINQ Query to Compiled LINQ Query to Auto-Compiled LINQ Queries in Entity Framework 5

Entity Framework 5 brings number of improvements and query performance improvement is one of them. In this article I’ll be talking all on query performances (EF1 to EF5) so that you can understand the improvements better.

TCP is a STATEful protocol and HTTP is a STATEless protocol, why?

One question i was asked in MCA Class today by a smart guy is Sir, I have a doubt, HTTP is based on TCP protocol and as we know TCP is a stateful protocol then why HTTP is stateless?

How to copy text from one textbox to another using jQuery blur

Here is a questing I received Hi Help me on jquery blur event I need to copy data from one textbox to another textbox.

Code First Database Migrations in MVC: in Hindi

Image
In this video you will learn how to use Migration feature in MVC Apps. I will create a new MVC Project using Code First Approach and then I will make some changes in model to look at the errors and then will use the Migration feature to migrate/update the database. Video is in Hindi Language.

Using Stored Procedure & Entity Framework in MVC 4 to create CRUD Apps: in Hindi

Image
In this video you will learn how to create CRUD Apps in MVC 4 using Stored Procedure and Entity Framework.

HTTP Error 404.0 - Not Found in MVC

Image
The Resource you are looking for has been removed, had its name changed, or is temporarily unavailable. I saw this error today while working on a MVC Web Project, this is a common error we get while running website and performing any CRUD (Create, Read, Update, Delete) operation. Stackoverflow is full of such queries so I decided to post the fix here. You might not find it useful for your case but I think majority of requests can be satisfied.

Browse With Option (Set Multiple Defaults) in Visual Studio 2012

Image
In Visual Studio 2012 we got some really exciting new features. And setting multiple defaults to browse with option is one of them. So, watch the video and see how it really works.

Media Only Queries in CSS3 / @media only screen and (max-width: 900px) { attributes; }

Image
If you remember, CSS2 added support for the media="screen" way of defining which stylesheet to use for which representation of the data. Now CSS3 added a new feature to this functionality, by adding media queries. Basically, this means you can change stylesheets or styles on the web page based on for instance the width and height of the viewport/browser.

The type 'System.Data.Objects.ObjectContext' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'

Today, I was developing an web application, I got titled error. I decided to post the fix for this.

ASP.NET Session States in SQL Server Mode (Session State Story)

Image
A session is defined as the period of time that a unique user interacts with a Web application. Active Server Pages (ASP) developers who wish to retain data for unique user sessions can use an intrinsic feature known as session state. Programmatically, session state is nothing more than memory in the shape of a dictionary or hash table, e.g. key-value pairs, which can be set and read for the duration of a user's session.

Free ebook: Beginning LINQ

Image
A new fashion to write Queries and address the impedance mismatch between programming languages and database. This e-book is based on my series of LINQ posts and I’m just consolidating all blog posts here. Get it Now PDF Version Download Size: 1.10 MB Total Pages: 36 Written  by Abhimanyu Kumar Vatsa ( itorian.com ) and Edited By: Deepak K Gupta .

LINQ Query Syntax and Method Syntax - Part 11

This is eleventh part of the ‘LINQ’ series posts that I have started from here . In the last post you learnt how to perform calculations in LINQ query. Now, in this post you will look at some differences between LINQ Query Syntax and Method Syntax used in LINQ.

Free ebook: Introducing Windows Server 2012 (RTM Edition)

Mitch Tulloch has updated his very popular free ebook on Windows Server 2012 based on the RTM version of the software.  A key feature of this book is the inclusion of sidebars written by members of the Windows Server team, Microsoft Support engineers, Microsoft Consulting Services staff, and others who work at Microsoft. These sidebars provide an insider’s perspective that includes both “under-the-hood” information concerning how features work, and strategies, tips, and best practices from experts who have been working with the platform during product development. More Here

Performing Calculations in LINQ Query - Part 10

Image
This is tenth part of the ‘LINQ’ series posts that I have started from here . In the last post you learnt how to transform source data/object into XML file and in this post will go ahead and learn how to perform some calculations in LINQ query.

Transforming Data Source objects into XML using LINQ - Part 9

This is ninth part of the ‘LINQ’ series posts that I have started from here . In the last post we explored customizing the LINQ’s ‘select’ statement to select subset of each source element. Now, in this post you will learn how to transform data source objects into XML.

Customizing LINQ’s ‘select’ statement - Part 8

This is eighth part of the ‘LINQ’ series posts that I have started from here . In the last post we explored how to join data from multiple data sources using ‘concat’ key. Now, in this post you will learn how to customize the LINQ’s ‘select’ statement to select subset of each Source Element.

Joining Multiple Data-Sources using 'Concat' Key in LINQ - Part 7

This is seventh part of the ‘LINQ’ series posts that I have started from here . In the last post we explored how to filter, order, group and join in LINQ. Now, in this post we will take a look at concate key used LINQ query to do joins.

My Speaking or In-Person Events

Okay, great to see you on this page. Here, i will list upcoming/past events in which i will be speaking. Hope to see you at event. 28 September 2019 By: Microsoft .NET Conf Topic: Building Full-stack C# Web Apps with Blazor in .NET Core 3.0 https://www.meetup.com/en-AU/Geek97/events/264182010 https://www.facebook.com/OfficialSunnySharma/posts/2544840485538206 05 October 2018 By: Microsoft App Innovation Circle Topic: Full day hands-on-labs on Cross platform Mobile app development with Xamarin https://www.microsoftevents.com/profile/form/index.cfm?PKformID=0x5004525abcd&wt.mc_id=AID730486_EML_5716749&fbclid=IwAR3LRmiUtTQ8dJvwc3nxeKJlUCtiZlXblJcmJRC68EcO5rdM-680vzHbaz8 30 May 2018 By: Microsoft App Innovation Circle Topic: Full day DevOps Workshop https://www.facebook.com/abhimanyukumarvatsa/posts/1934757206548496 21 April 2018 By: Microsoft Global Azure Bootcamp Topic: Getting Started with Cognitive Services URL: https://www.youtube.com/watch?v=dUt5pCcb_

Simple demo project on LINQ to SQL using Console Application

Image
In this video post, you will learn how to setup a simple project on LINQ to SQL using Console Application.

LINQ (Language Integrated Query) - Part 6

Image
This is sixth part of the ‘LINQ’ series posts that I have started from here . In the last post we explored selecting records using LINQ and its internals. Now in this post we will be looking at filtering, ordering, grouping and joining using LINQ.

LINQ (Language Integrated Query) - Part 5

Image
This is fifth part of the ‘LINQ’ series posts that I have started from here . In the last post we talked on how to setup a demo project to explore LINQ queries, I expect you too have a demo project with you, if not then visit Part 4 of this series and setup it. Let’s go ahead and explore selecting records using LINQ and explore internals.

Popular posts from this blog

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

Customize User's Profile in ASP.NET Identity System

Lambda two tables and three tables inner join code samples