filipececcon

using Domain.Entities;
 
namespace Repository.Repositories
{
    public class TeamRepository : RepositoryBase<Team>
    {
        
    }
}

filipececcon

using Domain.Entities;
 
namespace Repository.Repositories
{
  public class PlayerRepository : RepositoryBase<Player>
  {
      
  }
}

filipececcon

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq.Expressions;
using Domain.Contracts;
using Domain.Entities;
using Dommel;
   
namespace Repository

filipececcon

using System;
using System.Collections.Generic;
using System.Linq.Expressions;
using Domain.Entities;
namespace Domain.Contracts
{
 public interface IRepositoryBase<TEntity> where TEntity : BaseEntity
 {
 IEnumerable<TEntity> GetAll();
 TEntity GetById(int id);

filipececcon

namespace Domain.Entities
{
  public class Team : BaseEntity
  {
    public string Name { get; set; }
  }
}

filipececcon

namespace Domain.Entities
{
  public class Player : BaseEntity
  {
    public string Name { get; set; }
    public int Age { get; set; }
    
    // declarar as colunas de chave estrangeira da tabela
    public int TeamId { get; set; }
    public Team Team { get; set; }

filipececcon

namespace Domain.Entities
{
  public abstract class BaseEntity
  {
    public int Id { get; set; }
  }
}

filipececcon

USE master;
GO

--ALTER DATABASE Dapper_DB SET OFFLINE WITH ROLLBACK IMMEDIATE; DROP DATABASE Dapper_DB

CREATE DATABASE Dapper_DB;
GO

USE Dapper_DB;
GO

filipececcon

setInterval(function(){
   console.log("Running..." + Date());
}, 1000)

filipececcon

@ECHO OFF
node index.js