CSDL, SSDL and MSL sections in an EDMX file

  • CSDL (Conceptual Schema definition language) is the conceptual abstraction which is exposed to the application.
  • SSDL (Storage Schema Definition Language) defines the mapping with your RDBMS data structure.
  • MSL (Mapping Schema Language) connects the CSDL and SSDL.

CSDL, SSDL and MSL are actually XML files.


Tags: , , , , , , ,

What is pluralize and singularize in the Entity Framework?

“Pluralize” and “Singularize” give meaningful naming conventions to objects. In simple words it says do you want to represent your objects with the below naming convention:

  • One Customer record means “Customer” (singular).
  • Lot of customer records means “Customer’s” (plural, watch the “s”)

Tags: , , , , ,

World Countries Details!

countriesFind the following Excel file which contains all public details about world countries, you will get:

  • ISO3166 Alpha 2 .. like EG
  • ISO3166 Alpha 3 .. like EGY
  • ISO3166 Number 3 .. like 818
  • English Name .. like Egypt
  • Local Name .. like Mişr
  • Local Long Name .. like Jumhūrīyat Mişr al ‘Arabīyah
  • English Capital Name .. like Cairo
  • Local Capital Name .. like Al Qāhirah
  • Continent .. like AF
  • Demomyn .. like Egyptian
  • Latitude .. like 27
  • Longitude .. like 30

Click Countries to download the file or get it from my dropbox.

Leave a comment

Posted by on November 5, 2014 in Common


Tags: ,

SQL SERVER – Concurrency Basics – Guest Post by Vinod Kumar

SQL SERVER – Concurrency Basics – Guest Post by Vinod Kumar.

Leave a comment

Posted by on November 5, 2014 in MS SQL Server


What is Entity Framework?

Microsoft has given following definition:

The Microsoft ADO.NET Entity Framework is an Object/Relational Mapping (ORM) framework that enables developers to work with relational data as domain-specific objects, eliminating the need for most of the data access plumbing code that developers usually need to write. Using the Entity Framework, developers issue queries using LINQ, then retrieve and manipulate data as strongly typed objects. The Entity Framework’s ORM implementation provides services like change tracking, identity resolution, lazy loading, and query translation so that developers can focus on their application-specific business logic rather than the data access fundamentals.

Or simply: Entity framework is an Object/Relational Mapping (O/RM) framework. It is an enhancement to ADO.NET that gives developers an automated mechanism for accessing & storing the data in the database, and for working with the results, in addition to DataReader and DataSet.

Now the question is what is O/RM framework and why do we need it?

ORM is a tool for storing data from domain objects to relational database like MS SQL Server, in an automated way, without much programming. O/RM includes three main parts: Domain class objects, Relational database objects and Mapping information on how domain objects map to relational database objects (tables, views & storedprocedures). ORM allows us to keep our database design separate from our domain class design. This makes the application maintainable and extendable. It also automates standard CRUD operation (Create, Read, Update & Delete) so that the developer doesn’t need to write it manually.

Visit wikipedia for more information on Object-relational Mapping

There are many ORM frameworks for .net in the market like DataObjects.Net, NHibernate, OpenAccess, SubSonic etc. Entity Framework is an open source ORM framework from Microsoft.

Leave a comment

Posted by on November 1, 2014 in Data Access


Tags: , , , , , , ,

Microsoft Exam .. 100% Free!! (EXPIRED!)


I’m Microsoft Certified Trainer (MCT), I can help you to get a free exam voucher for any of Microsoft exams.

Just send me your:

  • First Name
  • Last Name
  • Microsoft Mail

Kindly, don’t do that unless you need to leave others to get the chance, reply on the same thread with the requested details and after registration you will get an email contains all of details which you want.


  • You’ve the chance to get one voucher only.
  • You should use it before November 30, 2014.
  • You cannot sell it, because it is assigned to you.
  • Don’t use different mail to get more than one voucher, because of your records will be distributed on more than one transcript, it’s illegal issue.
  • There’re limited seats, hurry up!
  • Feel free to contact me ( if you want to get further info about the issue.

Posted by on October 31, 2014 in Common


Tags: , , ,

SQL SERVER – GUID vs INT – Your Opinion

torage space is required than INT

via SQL SERVER – GUID vs INT – Your Opinion.

Leave a comment

Posted by on October 28, 2014 in MS SQL Server