AliIybar: Created page with "Category:dotnet == Install == dotnet add package Microsoft.EntityFrameworkCore 8.* dotnet add package Microsoft.EntityFrameworkCore.InMemory == program.cs ==

 us..."

2025-12-13T11:42:58Z

Created page with "Category:dotnet == Install == dotnet add package Microsoft.EntityFrameworkCore 8.* dotnet add package Microsoft.EntityFrameworkCore.InMemory == program.cs == <pre> us..."

New page

[[Category:dotnet]]

== Install ==
dotnet add package Microsoft.EntityFrameworkCore 8.*
dotnet add package Microsoft.EntityFrameworkCore.InMemory

== program.cs ==

<pre>
using Microsoft.EntityFrameworkCore;
.....
.....

builder.Services.AddDbContext<AppDbContext>(options =>
options.UseInMemoryDatabase("PeopleDb"));

builder.Services.AddScoped<IPersonRepository, PersonRepository>();

</pre>
they must be before '''var app = builder.Build();'''
== Entites/Person.cs ==
<pre>
public class Person
{
public int Id { get; set; }
public string Name { get; set; } = string.Empty;
public int Age { get; set; }
}
</pre>
== Repositories ==
=== Repositories/AppDbContext ===
<pre>
using api_sandbox.Entities;
using Microsoft.EntityFrameworkCore;

....
....

public class AppDbContext : DbContext
{
public AppDbContext(DbContextOptions<AppDbContext> options)
: base(options)
{
}
public DbSet<Person> People => Set<Person>();
}
</pre>

=== Repositories/IPersonRepository ===
<pre>
public interface IPersonRepository
{
Task<List<Person>> GetAll();

Task<Person> Create(string name, int age);
}
</pre>

=== Repositories/PersonRepository ===
<pre>
public class PersonRepository(AppDbContext dbContext) : IPersonRepository
{
public async Task<List<Person>> GetAll()
{
return await dbContext.People.ToListAsync();
}

public async Task<Person> Create(string name, int age)
{
var person = new Person {Name = name, Age = age};
dbContext.People.Add(person);
await dbContext.SaveChangesAsync();
return person;
}
}
</pre>

== Controller ==
<pre>
public class HomeController(IPersonRepository personRepository) : Controller
{
...
[HttpGet("add")]
public async Task<IActionResult> AddPerson()
{
await personRepository.Create("John", 30);
await personRepository.Create("Jane", 25);
return Ok("OK");
}

[HttpGet("get")]
public async Task<IActionResult> GetPerson()
{
return Ok(await personRepository.GetAll());
}
}
</pre>

InMemory database - Revision history

AliIybar: Created page with "Category:dotnet == Install == dotnet add package Microsoft.EntityFrameworkCore 8.* dotnet add package Microsoft.EntityFrameworkCore.InMemory == program.cs ==
us..."