I have a field in the database that is in the following format: YYYYMM
Using procedure I can normally search these fields:
WHERE I.DT_INCL >= @inicio
AND I.DT_INCL <= @final
When I try to pass the query to linq it returns the...
I would like to translate the following SQL statement to a lambda expression:
SELECT TOP 1 * FROM tbPessoa order by NEWID()
What do I put in the OrderBy that will be accepted?
var pessoa = contexto.tbPessoa.OrderBy(???).FirstOrDe...
I believe this has already been asked before. I researched but did not find it.
I'm having trouble with this query, specifically on the ThenBy command that tries to sort the sub-list of objects. I know it's in it because when you comme...
I have the following LINQ query that is in a method that returns all products:
var query = from p in Produtos
select new Produto
{
ProdutoId = p.ProdutoId,
Descricao = p.Descricao,
Preco = p.Preco,
Estoq...
Having this data model I want to generate a SQL in the Entity Framework with < a href="http://msdn.microsoft.com/en-us/library/bb425822.aspx"> Linq and
How do I populate two combobox's with linq to sql where in a combobox for example I have countries and in another I have cities? How do they automatically change the values? I leave the image below as I filled out one, if there are any errors an...
How to use ForEach() of List in the implementation below
using System.Collections.Generic;
public class Program
{
public static void Main()
{
List<Pessoa> pessoas = new List<Pessoa>();
pess...
I'm going through the following problem, I am putting an API into a forum application and this API needs an endpoint to return a collection of Forum that have the% property of% null. Then I put the following endpoint :
[AllowAnonymou...
In my last questions I was creating some methods to automate some queries. It's cool, but now I need to control access to methods by specifying a sequence.
When using the Select () method, I can not access it again. After the Where () metho...