Dt1nh6: 1 revision imported

2016-05-09T13:27:29Z

1 revision imported

Macrop at 10:08, 2 February 2016

2016-02-02T10:08:29Z

New page

[[Category:Entity Framework]]
[[Category:ASP.NET5]]

== Installation ==
PM> Install-Package EntityFramework.MicrosoftSqlServer -Pre

== Creating Models ==
=== Models ===
<pre class="brush:csharp;">
public class Parent
{
public int Id {get; set;}
public string MasterName {get; set;}
public ICollection<Child> {get; set;}
}

public class Child
{
public int Id {get; set;}
public string ChildName {get; set;}
}

</pre>
=== Context ===
Then we start creating context. Create a **TestContext.cs** file in Models folder

<pre class="brush:csharp;">
public class TestContext : DbContext
{
public DbSet<Parent> Parents {get; set;}
public DbSet<Child> Children {get; set;}
}
</pre>

Once we write **DbContext** in the class above it will be underlined and as a fix VS suggest to get EF7 Nuget package. Click this suggestion.

== Configure Services ==
in **Startup.cs** under **ConfigureServices** section add the lines below

<pre class="brush:csharp;">
services.AddEntityFramework()
.AddSqlServer()
.AddDbContext<TestContext>();
</pre>

**TestContext** here is the one we defined in Context section

== Configure Db Provider ==
in config.json add a new section named Data
<pre class="brush:csharp;">
"Data":{"TestContextConnection":"Server=SomeServer;
Database=TestDb;
Trusted_Connection=true;
MultipleActiveResultSets=true;"}

</pre>

in **TestContext.cs** file again
<pre class="brush:csharp;">
protected override void OnConfiguring(DbContext TestContext, OptionsBuilder optionsBuilder)
{
var connString = Startup.Configuration["Data:TestContextConnection"]
optionsBuilder.UseSqlServer(connString)
}
</pre>

== Migrations ==
in **project.json** file add a dependency and add a line to **commands** section
<pre class="brush:csharp;">
"EntityFramwework.Commands", "7.0.0-beta8"

// in commands section
"ef":"EntityFramework.Commands"
</pre>

Then in Command Prompt under the project folder
<sxh>
dnx ef migrations add InitialDatabase
</pre>
**ef** comes from project.json commands section and InitialDatabase is a name that we gave to this migration.

in **TestContext.cs** file

<pre class="brush:csharp;">
public class TestContext:DbContext
{
//in constructor add the line below
public TextContext()
{
Database.EnsureCreated();
}
}
</pre>
This will create the database itself and if any migrations nedd to be executed it will execute them at the same time.

== Seeding Data ==
Create **TestContextSeedData.cs** file in models folder
<pre class="brush:csharp;">
public class TestContextSeedData
{
private TestContext = _context;
public TestContextSeedData(TestContext context)
{
_context = context
}
public void EnsureSeedData()
{
if(! _context.Masters.Any())
{
var rMaster = new Master()
{
MasterName = "test",
Children = new List<Child>()
{
new Child(){ ChildName = "TestChild"},
new Child(){ ChildName = "TestChild2"}
}
}
_context.Masters.Add(rMaster);
_context.Children.AddRange(rMaster.Children);
_context.SaveChanges();
}
}
}
</pre>

in startup.cs under Configure method
<pre class="brush:csharp;">
public void Configure(TestContextSeedData seeder)
{
seeder.EnsureSeedData();
}
</pre>

To use this class we need to register it in **startup.cs** file in **ConfigureServices**
<pre class="brush:csharp;">
services.AddTransient<TestContentSeedData>();
</pre>

=== Options ===
* AddTransient : only one instance supplied
* AddSingleton :
* AddInstance :
* AddScoped : an instance will be created whenever needed

Stop and restart web server to activate services changes

← Older revision	Revision as of 13:27, 9 May 2016
(No difference)

Entity Framework 7 - Revision history

Dt1nh6: 1 revision imported

Macrop at 10:08, 2 February 2016