Tesla - TSLA (USA)

public List<tEmployee> GetEmployees()
{
    using (var context = new YourDbContext())
    {
        return context.tEmployee.ToList();
    }
}

using Microsoft.EntityFrameworkCore;
using System.Collections.Generic;
using System.Linq;
using System.Threading;
using System.Threading.Tasks;

[Table("tEmployee")] // säkrar att entiteten mappar till tabellen tEmployee
public class tEmployee
{
    [Key]
    public int Id { get; set; }
    public string FirstName { get; set; } = default!;
    public string LastName  { get; set; } = default!;
    public string Email     { get; set; } = default!;
    // ... fler fält
}

public class AppDbContext : DbContext
{
    public AppDbContext(DbContextOptions<AppDbContext> options) : base(options) { }

    public DbSet<tEmployee> Employees { get; set; } = default!;
    // alt: public DbSet<tEmployee> tEmployee { get; set; }  // om du vill att DbSet:en heter likadant
}

public class EmployeeRepository
{
    private readonly AppDbContext _db;
    public EmployeeRepository(AppDbContext db) => _db = db;

    public async Task<List<tEmployee>> GetEmployeesAsync(CancellationToken ct = default)
    {
        return await _db.Set<tEmployee>()
            .AsNoTracking()
            .OrderBy(e => e.LastName).ThenBy(e => e.FirstName)
            .ToListAsync(ct);
    }
}