How to Perform Add Range Operation using Entity Framework

Loading

How to Perform Add Range Operation using Entity Framework

Introduction

In this blog we will see how to perform add range operation using entity framework.

Step 1: Create console application

Employee.cs

namespace AddRangeEFApp
{
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Entity.Spatial;
[Table("Employee")]
public partial class Employee
{
public int Id { get; set; }
[StringLength(50)]
public string FirstName { get; set; }
[StringLength(50)]
public string LastName { get; set; }
}
}

Employeecontext.cs

namespace AddRangeEFApp
{
using System;
using System.Data.Entity;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
public partial class EmployeeContext : DbContext
{
public EmployeeContext()
: base("name=EmpConn")
{
}
public virtual DbSet<Employee> Employees { get; set; }
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Entity<Employee>()
.Property(e => e.FirstName)
.IsUnicode(false);
modelBuilder.Entity<Employee>()
.Property(e => e.LastName)
.IsUnicode(false);
}
}
}

Web.config

<connectionStrings>
<add name="EmpConn" connectionString="data source=WIN-B4KJ8JI75VF;initial catalog=EmployeeDB;user id=sa;password=India123;MultipleActiveResultSets=True;App=EntityFramework" providerName="System.Data.SqlClient" />
</connectionStrings>

Program.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace AddRangeEFApp
{
class Program
{
static void Main(string[] args)
{
IList<Employee> newEmployee = new List<Employee>();
newEmployee.Add(new Employee() { FirstName = "Jon", LastName = "Aw" });
newEmployee.Add(new Employee() { FirstName = "Syed", LastName = "Khan" });
newEmployee.Add(new Employee() { FirstName = "James", LastName = "Still" });
using (var objEmpContext = new EmployeeContext())
{
objEmpContext.Employees.AddRange(newEmployee);
objEmpContext.SaveChanges();
}
Console.ReadKey();
}
}
}

Output of the application looks like this

Summary

In this blog we have seen how we can perform add range operation using entity framework. Happy coding!