Questions tagged as 'linq'

Tagged questions
1
answer

Linq to Entities - Count elements of a query that references two contexts

I have the following query: var query = (from q1 in query1 join q2 in query1 on q1.idGenerico equals q2.idGenerico into q2Left from q2 in q2Left.DefaultIfEmpty() join q3 in query3 on q2.idGenerico equals q3....
asked by 16.03.2018 / 19:17
1
answer

How to perform a Left Join with LINQ C # using my SQL?

Example that works in SQL: select * from Doacoes inner join Projetos on Projetos.IdProjeto = Doacoes.IdProjeto left join Pedidos on Doacoes.IdDoacao = Pedidos.IdDoacao left join Recompensas on Pedidos.IdRecompensa = Recompensas.IdRecompensa...
asked by 07.12.2017 / 12:39
1
answer

Attribute type varbinary sql server with C #

This DocumentoPDF column so far was not used by the system: HomeIamnotsurewhattodowiththis:Thisistheerrormessage:"já existe um DataReader aberto associado a este command que deve ser fechado primeiro" The error already occurs...
asked by 07.06.2017 / 03:57
1
answer

Difficulty in filtering information

I know my problem is logical and this should start with me, I know, but sometimes a light, not a ready code, but the pointing of a path helps us a lot. 1) I have 6 ComboBox in my View that make the filters for a search. 2) This search shou...
asked by 01.10.2014 / 14:20
1
answer

How do I order a Complex List?

How do I sort a complex list? Home I have this list below and I need to sort by TypeName and TypeName : public class Tipo() { public int IdTipo {get; set;} public string NomeTipo {get; set;} public List<S...
asked by 03.10.2018 / 14:49
1
answer

lambda expression gives conversion error

This is my linq with lambda: public JsonResult CarregaDescricaoRede(string _tipo_rede, string _uf, string _cidade) { var resultado_rede_descricao = (from _pdv in db.PDV .Where(r =...
asked by 30.09.2014 / 16:26
1
answer

Compare lists that are exactly the same

I'm trying to implement a list comparison method that checks to see if they match. It should return true when the two lists passed by parameter are exactly the same (number of elements, elements and ordering). I was able to develop part of...
asked by 09.09.2018 / 02:29
1
answer

Turning float or double into date within a lambda

In the BD it has a field with a float value, which is actually the number of days from the 28/12/1800 date, which the Clarion programming language stores. Well, I have a REST service that is consumed by an Android App. What happens is that I...
asked by 11.09.2017 / 17:27
2
answers

Make JOIN with 2 classes [closed]

How to make a JOIN for the Customer Code to appear in the Name?     
asked by 26.09.2015 / 01:45
1
answer

Convert DateTime to Date [duplicate]

I need to compare a date without the time, only ("dd/MM/yyyy") with the database with Linq , but I am not able to transform from DateTime("dd/MM/yyyy HH:mm:s") to Date("dd/MM/yyyy") format?     
asked by 24.10.2018 / 21:09