I wanted to know how to do NOT IN in the next query
select * from WFRules
where (Class = 'DoDesign' or ParentId = 0)
and ParentType not in (5,8,9,10,11)
and Type not in (5,8,9,11,15,33,34,35,37,38,3...
The method is like this:
public List<CivarTransporteService.Model.Cliente> getClientes()
{
using (CivarTransporteService.Model.CivarTransporteModelContainer context =
new Model.CivarTransporteModelContainer())
{...
I need to translate the following query from SQL to LINQ in .NET with C #:
This is the SQL query to translate:
SELECT COUNT(id_documento)
FROM documento
I need the value to be stored in a variable or to capture the n...
I am very new using LINQ and I have done few things, right now I have an SQL query that I must implement in LINQ and I have no idea how it is done.
SELECT Boletas.Boleta, DATEPART(DW, CAST(Boletas.Fecha AS datetime)) AS DiaDeLaSemana,...
I am working on C #, using Linq Dynamic to do some sorting, so I was generated the need to obtain the names of the properties as string .
When the properties are simple, they do not generate any conflict, since I can use nameof()...
I want to make a classification so to speak of a list that I have, I'm trying to do it with linq.
well this is what I want ..
Result.
This the information with which I count.
Proveedor: Videmont
Cap. Morgan = $450.12
ET. Negra = $620.32
P...
Hello friend I have a problem with a table I have a field called names within this table and I have a list of names which I want to exclude from the table based on the name field.
I have the following but it does not work for me.
var DataRows...
How can I convert the following SQL query to Linq?
SELECT Facturas.IDFactura, SUM(MovimientosDineros.Valor) AS Totalaportado
FROM Facturas
JOIN MovimientosDineros ON Facturas.IDFactura = MovimientosDineros.IdFactura
GROUP BY Facturas.IDFactura...
This is my query on the sql server and everything works fine
select * from DetalleNotas
order by len(ColProduct), ColProduct
PROCT1
PROCT2
PROCT3
PROCT4
PROCT5
PROCT6
PROCT7
PROCT8
PROCT9
PROCT10
but I want my query in linq
I trie...
I'm getting the following error when returning an object when validating the login:
You can not implicitly convert the type 'System.Linq.IQueryable' 'to' Business.clsUser.ValidSessionU '. An explicit conversion already exists (check if a c...