public List <Player_Grid_BD> Pesquisar_Game()
{
string sqlA = "Select * FROM TB_PLAYER";
using (var conn = new SqlConnection(@"data source=.\SQLEXPRESS;initial catalog=BD_GAME;integrated security=True;MultipleActiveResultSets=True"))
{
var cmd = new SqlCommand(sqlA, conn);
List <Player_Grid_BD> dados = new List <Player_Grid_BD>();
Player_Grid_BD p = null;
try
{
conn.Open();
using (var reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
p = new Player_Grid_BD();
p.Codigo = Convert.ToInt16(reader["CD_PLAYER"]);
p.Nome = reader["NM_PLAYER"].ToString();
dados.Add(p);
}
}
}
finally
{
conn.Close();
}
return(dados);
}
}
public void Inserir(BD_GAMEEntities oBD, Player_Grid_BD pPlayer_BD)
{
Player_BD oPlayer = new Player_BD();
oPlayer.Nome_Player = pPlayer_BD.Nome;
oPlayer.Codigo_Game = pPlayer_BD.Codigo_Game;
oBD.Player_BD.Add(oPlayer);
oBD.SaveChanges();
}