How to know the type of field in the database with EntityFramewors C # [UWP]

1

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);
}
    
asked by Wilmilcard 17.10.2018 в 18:54
source

0 answers