Guide to Entity Framework with

[
 9 
]
using NHibernate;
using FluentNHibernate.Cfg.Db;
using FluentNHibernate.Automapping;
using NHibernate.Cfg;
using NHibernate.Tool.hbm2ddl;
using System.Reflection;
namespace Packt
{
public static class DataManager
{
private static ISessionFactory sessionFactory = null;
private static readonly string businessObjectsNamespace = 
"Packt.Entity.Mappings";
private static readonly string connectionString = @"Data 
Source=JOYDIP-PC\SQLServer2014;
Initial Catalog=Security;Integrated Security=True";
private static ISessionFactory SessionFactory
{
get
{
if (_sessionFactory == null)
{
//Code to create a new session factory instance and load the 
business entities
}
return sessionFactory;
}
}
public static ISession OpenSession()
{
return SessionFactory.OpenSession();
}
}
}
Note that you can make a call to 
DataManager.OpenSession()
to open the database 
connectivity session.
Entity Framework 6 is a mature ORM and comes up with many powerful features. 
When you use Entity Framework, you can concentrate more on writing application 
logic rather than writing the database connectivity code. This reduces development 
time and effort greatly.

---

Introducing the ADO.NET Entity Framework
[
 10 
]
Language Integrated Query
(
LINQ
) is a query translation pipeline that you can 
use to integrate your queries into the object model. LINQ provides you with a 
framework that you can use to access relational data in a strongly typed way.
LINQ provides a great way to query in-memory objects.
Here are the various forms that LINQ comes up with:
•