Questions tagged as 'linq-to-sql'

Tagged questions
1
answer

Is it possible to obtain two independent results (sum) from a single query in LINQ?

I am modifying a program and I want to obtain two sums independently of the id and save them in independent variables one of another. It would also be useful to obtain a table resulting from a line with only the two columns added. With this e...
asked by 22.08.2018 / 12:18
1
answer

IErrorInfo.GetDescription error with E_FAIL (0x80004005)

I have the following function which receives the path of an Excel file to open it and read it to add users, I execute it in my project from Visual Studio and it runs without problems, when I take it to the server where it should work it shows me...
asked by 24.07.2018 / 18:50
1
answer

Query in LINQ, How to concatenate fields

Good afternoon, I have the following left join var innerJoin = from emp in db.Tbl_Empleado join mb in db.Tbl_MarcacionesBiometrico on emp.EmpId equals mb.EmpId into MarcBio...
asked by 30.11.2017 / 00:00
2
answers

Linq query does not respond after updating Stored Procedure in EntityFramework

I'm working with EntityFramework 6 , I have my model created (First DataBase) for quite some time. In my project I have some queries with LINQ and others (to optimize times) made with Stored Procedures (SP). It worked correctly until I n...
asked by 20.04.2017 / 17:22
1
answer

Error in Enumerable.Except method of LinQ

I have the following code: var vistaRecibos = (from r in ctx.RECIBOSPAGO_DETALLE_GENERAL select new { r.idrecibopago,...
asked by 27.03.2017 / 21:11
1
answer

Classes Name using LINQ to SQL

When using LINQ to SQL when I put the tables in the dbml classes come in Plural, is there any way to put them in the singular?     
asked by 01.11.2016 / 19:35
3
answers

SQL query, LINQ

I have the following query SELECT tp.Nombre, tp.IdTipoContacto FROM TipoContacto tp LEFT JOIN Contacto c on tp.IdTipoContacto = c.IdTipoContacto WHERE NOT tp.Nombre = 'Compañia' This brings me back Facturacion 2 Facturacion...
asked by 08.09.2016 / 19:16
1
answer

Go from Linq to Sql

I have the following expression from Linq: Tabla.Skip(ind_pag).Take(cant_filas).ToList() How would it be on MySql ???     
asked by 21.08.2016 / 00:13
0
answers

add column type DateTime

What I want to do is add the column with the same IdExamen that throws the result and subtract me with another of the same type. this is what I tried without success, someone who has gone through I am, thanks public JsonResult ContarTiempo(...
asked by 16.12.2018 / 16:12
1
answer

Query Linq C #

I have a small problem and I find a solution. I have to take the name of a person and with the name of the school DB_Entities db = new DB_Entities(); // es generada por el Entitie framework public JsonResult GetPersona(string...
asked by 25.10.2018 / 18:36