approaches in language teaching Part 6 How to seed database with test data using entity framework

Text version of the video
http://csharp-video-tutorials.blogspo...

Slides
http://csharp-video-tutorials.blogspo...

Entity Framework - All Text Articles
http://csharp-video-tutorials.blogspo...

Entity Framework - All Slides
http://csharp-video-tutorials.blogspo...

Entity Framework Playlist
https://www.youtube.com/playlist?list...

Dot Net, SQL, Angular, JavaScript, jQuery and Bootstrap complete courses
https://www.youtube.com/user/kudvenka...


So far in this video series, we have been manually populating the database with test data using the insert sql script. Entity Framework can automate this. We will be working with the example we worked with in Part 5. Here are the steps.

Step 1: Right click on the project in solution explorer and add a class file with name = EmployeeDBContextSeeder.cs

Step 2: Copy and paste the following code in EmployeeDBContextSeeder.cs file
using System.Collections.Generic;
using System.Data.Entity;

namespace Demo
{ public class EmployeeDBContextSeeder : DropCreateDatabaseIfModelChanges[EmployeeDBContext] { protected override void Seed(EmployeeDBContext context) { Department department1 = new Department() { Name = "IT", Location = "New York", Employees = new List[Employee]() { new Employee() { FirstName = "Mark", LastName = "Hastings", Gender = "Male", Salary = 60000, JobTitle = "Developer" }, new Employee() { FirstName = "Ben", LastName = "Hoskins", Gender = "Male", Salary = 70000, JobTitle = "Sr. Developer" }, } }; Department department2 = new Department() { Name = "HR", Location = "London", Employees = new List[Employee]() { new Employee() { FirstName = "Philip", LastName = "Hastings", Gender = "Male", Salary = 45000, JobTitle = "Recruiter" }, } }; Department department3 = new Department() { Name = "Payroll", Location = "Sydney", Employees = new List[Employee]() { new Employee() { FirstName = "Steve", LastName = "Pound", Gender = "Male", Salary = 45000, JobTitle = "Sr. Payroll Admin", }, } }; context.Departments.Add(department1); context.Departments.Add(department2); context.Departments.Add(department3); base.Seed(context); } }
}

Step 3: Copy and paste the following line in Application_Start() method Global.asax file
Database.SetInitializer(new EmployeeDBContextSeeder());

Step 4: Remove the following Table and Column attributes from Employee.cs file.
[Table("tblEmployees")]
[Column("First_Name")]

At this point Employee class should look as shown below.
public class Employee
{ public int Id { get; set; } public string FirstName { get; set; } public string LastName { get; set; } public string Gender { get; set; } public int Salary { get; set; } public int DepartmentId { get; set; } [ForeignKey("DepartmentId")] public Department Department { get; set; } public string JobTitle { get; set; }
}

Step 5: Run the application and notice that the Sample database, Departments and Employees tables are created and populated with test data automatically.

approaches in language teaching Part 6 How to seed database with test data using entity framework
226 Likes	226 Dislikes
106,582 views views	524K followers
Education	Upload TimePublished on 12 May 2014

Related keywords

approach definition,asp.net core docker,wcf vs web api,ado.net core,sql server management studio,webkinz,webadvisor,craigslist nj,wcf one piece,asp.net core 3,ajax players,weber grill parts,webtoon,tutorials by hugo,csharp corner,mvc design pattern,asp.net machine account,servers for minecraft,asp.net core dependency injection,ado.net tutorial,entity framework with oracle,database normalization,code first migrations to update the database,services angular,approaches and methods in language teaching,code first approach in mvc,database management system,ajax ontario,asp.net mvc tutorial,asp.net cos'è,csharp assembly,entity framework c#,database types,tutorialspoint python,sql join,services briefcase,asp.net core web api,data entry,ajax jquery,wccftech,craigslist ny,data warehouse,asp.net zero,csharp foreach,server memes,sql date format,services online,database online,chase,approach to diagnostics of marketing complex of industrial enterprise,serverless architecture,server resume,data science,wcf c#,server books,tutorialspoint javascript,code first add migration,mvcc connect,entity framework core code first,ado.net mysql,services technologies gps,database.ensurecreated(),data scientist,ajax deadpool,server jobs,cvs,website,mvc tutorial,approach s60,costco hours,wcf service application,tutorialspoint spring,serverless,wcf soap,wcf cat,cool math games,wcf test client,entity framework core,services & training hse colombia sas,servicestack,citibank,asp.net core identity,sql union,ajax parking,sql database,asp.net core logging,mvconnect,cunyfirst,asp.net guida,wcf nba,csharp download,wcfi foundation,csharp online,code first girls,wcf authentication,tutorials near me,http://asp.net,server 2019,chernobyl,ado.net descargar,web of dreams,serverminer,entity framework update,ajax cleaner,code first entity framework core,ado.net visual studio 2019,webassign,code first entity framework,database diagram online,ado.net vs entity framework,data star trek,data lake,ado.net visual studio 2017,csharp list,sql like,asp.net mvc,asp.net core tutorial,sqlite,wcfm,code first migrations,ajax roster,approach traduccion,code first approach in .net core,mvc architecture,code first c#,http://ado.net,approachable,approach translate,asp.net core mvc,ajax soccer,approachment,server hosting,data scientist salary,database schema online,wcfi,code first vs model first,ajax dish soap,capital one,server rack,tutorialspoint html,data mining,csharp interface,approaching,entity framework 6,database disk image is malformed,code first entity framework c#,craigslist,webroot,tutorialspoint reactjs,ajax request,wcf dragon ball,asp.net core 2.2,database administrator,tutorialspoint python 3,sql developer,webster,services transmission company sas,sql group by,asp.net core signalr,services manager,database index,mvc framework,ajax paving,mvc near me,data analysis,entity framework database first,database migration,entity framework mysql,database schema,tutorialspoint spring boot,entity framework core mysql,database developer,code first or database first,mvc map,csharp online compiler,asp.net download,sql between,code first vs database first,data analyst salary,ado.net c# pdf,services tag dell,wcf 2019 nba,entity framework core database first,csharp switch,ado.net ventajas y desventajas,code first create database,csharpstar,wcf tutorial,entity framework many to many,approaching nirvana,tutorialspoint,ajax meaning,csharp-video-tutorials.blogspot,tutorials dojo,central park 5,csharp string format,ado.net c#,asp.net core github,server status,ajax fc,server jobs nyc,asp.net core swagger,approach meaning,sql formatter,credit karma,services group,server error in '/' application,data entry jobs,services windows,asp.net core 3.0,sql injection,tutorialspoint c#,wcf ria services,calculator,ado.net entity data model,sql insert,data analytics,approachable en español,tutorialspoint tableau,services google play apk,sqlyog,database first,asp.net core 3 release date,sql server,server job description,tutorials by a,servicenow,entity framework tutorial,webcam,mvc hours,webmd symptom,csharp array,csharp enum,ajax call,asp.net core 2. guida completa per lo sviluppatore,asp.net core,server pro,server status ffxiv,database is,cheap flights,approach golf,webcrims,asp.net core hosting,services sas,database management systems,tutorialspoint java,tutorialspoint java compiler,approach synonym,datadog,webmd,csharp to json,college football,ado.net dataset,csharp dictionary,cnn,website builder,tutorialspoint sql,asp.net web api,server side rendering,weber grills,sql server 2017,code first entity framework tutorial,tutorialspoint spark,mvc nj,data breach,ado.net oracle,asp.net core download,csharp to vb.net,entity framework core nuget,approach in spanish,entity framework core postgresql,webster bank,approach ejemplos,webstaurant,datacamp,tutorialsystems,ajax post,services fms publish announcement,services.msc no abre,approaching the unknown,ajax jersey,csharp operator,code first foreign key,asp.net core razor pages,server duties,asp.net core environment variables,csharp random,database design,century 21,entity framework core oracle,code first database,services consultores,services consulting,database diagram,mvcsd,services.msc,mvcsc,ado.net pdf,asp.net core configuration,ajax marvel,sql update,asp.net tutorial,code first default value,mvc medical,ado.net entity data model visual studio 2019,wcfs international curriculum,mvc2,ado.net entity data model visual studio 2017,chase online,wcf api,entity framework include,costco,database это,server jobs near me,webex,sql meaning,sql tutorial,entity framework join,sql commands,code first migrations existing database,data universe,ado.net entity framework,ajax tavern,tutorialsteacher,databases list,code first mvc,ajax javascript,database,services desk,entity framework postgresql,data visualization,ajax greek,csharp tutorial,mvc pattern,ado.net sql server,ado.net connection,asp.net identity,approaches to teach english,mvcu,databricks,approaches,asp.net core middleware,data analyst,entity framework code first,wcf web service,mvc webadvisor,web store,mvcc,webmail,mvci,mvctc,entity framework migrations,