Posts

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.
Post a Comment
Read More »

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.
Post a Comment
Read More »

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_
Post a Comment
Read More »

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.
Post a Comment
Read More »

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.
Post a Comment
Read More »

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.
1 comment
Read More »

LINQ (Language Integrated Query) - Part 4

Image
This is fourth part of the ‘LINQ’ series posts that I have started from here . And in this post, you will learn how to setup a demo project to explore LINQ queries. I will use my preinstalled ‘Northwind’ database that you can download from here and install it in SQL Server Management Studio.
Post a Comment
Read More »

Monthly Blogging Report: August 2012

Consolidating all blog posts monthly are very refreshing as it gives me chance to go back and see what I did in last month and for readers gives the chance to see what he not followed up.
Post a Comment
Read More »

LINQ (Language Integrated Query) - Part 3

Image
This is third part of the ‘LINQ’ series posts that I have started from here . And in this post, you will learn something on ‘Generic’ like what are generic types, why we need it in LINQ?
Post a 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 »

Lambda two tables and three tables inner join code samples

In this blog post you will learn inner join using lambda queries. There will be two samples, in first sample you will see how you can join two tables and in second sample you will see how you can extend even further to join three tables and so on. I will sample in-memory data, but the same implementation will work with IQueryable (lazy query) too. Here's the code snippet:- namespace ConsoleApp1 {     class Program     {         static void Main()         {             var table1 = new List<Table1>();             table1.Add( new Table1 { Id = 1, Name = "Name 1" , Address = "Address 1" });             table1.Add( new Table1 { Id = 2, Name = "Name 2" , Address = "Address 2" });             table1.Add( new Table1 { Id = 3, Name = "Name 3" , Address = "Address 3" });             table1.Add( new Table1 { Id = 4, Name = "Name 4" , Address = "Address 4" });   
Read More »