I just have a table:
CREATE TABLE Parametros(
Empid int NOT NULL CONSTRAINT [FK_Parametros_Empid] REFERENCES Empresa(id),
Codigo varchar(25) NOT NULL,
Valor sql_variant NULL,
CONSTRAINT [PK_Parametros] PRIMARY KEY (Empid,Codigo))
And then when I want to know what data I have stored in Valor
I make this query:
SELECT Empid,
Codigo,
Valor,
SQL_VARIANT_PROPERTY(Valor,'BaseType') AS 'DataTypell'
FROM Parametros
And then I bring it in SQL but I need to bring that data in C # when I do the query in Entity Frameworks, how do I bring it?
At the moment I have a method like this:
public async Task<Parametro> GetAsync(int empid)
{
return await _db.Parametro.FindAsync(empid);
}