Mavin world

Elegant short notes on technical concepts

Basic note on String Comparision Enumeration

 Sberry wants 'Delineate' to be not equal to DELINEATE which is again not equal to dElINeate and sort them based on their case and culture. How to do...? Here comes the StringComparision enum which we can pass to the comparison, equal... Continue Reading →


Clear out Confusion on Add, Attach, Create DbSet Methods.

With Sberry, let's dive in to clear out the confusion around the Add, Attach and Entry, Create and New methods of DbSet and DbContext of Entity framework. Add public virtual object Add( object entity) Simply put Adds the entity to... Continue Reading →

Handy note on Configuration and InitializationStrategy in .Net EntityFramework

The default Entity framework conventions can be overridden through two methods 1.Data Annotations 2.Fluent API. Entities and properties are configured through EntityTypeConfiguration. The ModelBuilder class provides Enity (),which return EntityTypeConfiguration object which is  used in configuration.  We can separate out... Continue Reading →

In Built Delegates in C#

Func<T,TResult>, Action and predicate delegates are inbuilts present in the system namespace. Func delegate can take one or more parameters and returns a value. The parameters can be zero to 16 and the last parameter represents a return value. If... Continue Reading →

One stop for all basic Entity framework Migration commands

This post thows up a glimpse on the basic commads syntax and usage serving as a quick reference when ever you are struck out for pretty basic thing. Let’s get started. Want to enable Migrations in your Project ? Enable-Migrations... Continue Reading →

Quick Note on Apply Operator in Sql Server

  Hello Welcome to Sberry blog. This post gives you a quick snap of what APPLY operator in sql server. Learn now with Sberry. APPLY operator in a Transact-SQL query is used to join a table to a table-valued function... Continue Reading →

A Shallow Dive into EntityTypeConfiguration

  Hello! Strawberry Sberry here. This time strawberry in search of a new tech friend. Sberry came to know about EntityTypeConfiguration from its previous tech friend DbContext. Let's help Sberry discover about its new friend and connect them. Go Go... Continue Reading →


I often got stuck in the jargon of technical words and how are they related. For those who are struggling like me to comprehend the technical buzz of words, this post illustrates the basic difference between the INFORMATION_SCHEMA, sys, sys.objects,... Continue Reading →

INFORMATION_SCHEMA the un-sung system views

Perfect one shot for the difference between INFORMATION_SCHEMA and the SYSTEM VIEWS


SQL Studies

I spend a reasonable amount of time looking through various forums, answering some questions and reading the answers to others. One of the things I’ve noticed is that while I frequently see system views referenced I only very rarely see the INFORMATION_SCHEMA views mentioned. This seems rather strange to me since I think most (although by no means all) of the people who work with system views know about the INFORMATION_SCHEMA ones.

For those who haven’t seen them before I’m going to show a few examples, comparing each INFORMATION_SCHEMA (owned by the INFORMATION_SCHEMA schema) view to the more common sys (owned by the sys schema) system view I see. Note: I’m only showing the base sys system view. In most (if not all) cases retrieving the same information will require joining several sys system views and/or functions together.





View original post 483 more words

Create a website or blog at

Up ↑