Best answeres tagged with linq-to-sql

2

answers

Help with LINQ, query in .Net

Good morning, guys, I'm in need of help with LINQ. I'm trying to perform the following query through linq: SELECT NFE_SAIDA.NFESAI_SEQUENCIA FROM CAD_NFE_SAIDA NFE_SAIDA LEFT JOIN CAD_NFE_SAIDA_ESTACOES NFE_SAIDA_ESTACOES ON NFE_SA...

asked by 29.12.2017 / 11:37

1

answer

Select Suppliers by Fantasy Name

I have a PRODUCT registration form and there is a relationship with the SUPPLIER table, as shown in the image below: ClickingtheSEARCHPROVIDERbuttonwilldisplaythisView Now I need to develop a text box that when typing a value it looks f...

asked by 10.10.2015 / 23:10

2

answers

Filling Label with Linq using ToList ()?

asked by 16.08.2017 / 03:07

1

answer

How do I search for the record when the table has composite primary key?

I have in my database the table t_command_control . This table has a composite primary key formed by the CD_STATION and CD_COMMAND fields. If the primary key was simple (just as CD_STATION field) I would use the...

asked by 30.11.2014 / 18:50

2

answers

Mapping a Listlong in LINQ to SQL - Windows Phone 7.1

Problem I'm starting an application for Windows Phone 7.1, and I'm implementing the database, but I came across a situation that I did not find any similar situation to try to solve, and I also did not find anything to help me with the docu...

asked by 17.10.2014 / 04:38

1

answer

How to transform lambdas expressions into sql commands?

How can I manipulate expressions to help automate the creation of SQL statements like Linq to SQL? So: using EntityFramework I can make queries such as: var livros = contexto.Livros .Where(livro => livro.SaldoEstoque > 0) .Orde...

asked by 10.11.2014 / 23:24

1

answer

Bring a newly added ID to put in a textbox c # windows form

I ask for help to do the following, I make an insert via procedure after saving I want to fill the textbox with the id created so I can use it to associate with my item Ijustneedtheordercodetoenterthetextbox.Thanksinadvanceforyourhelp.NewButton...

asked by 04.11.2017 / 19:39

1

answer

LINQ to SQL with entities that already exist, inheritance and composition

I'm starting to study LINQ to try to implement a project I'm working on. For examples in articles as in videos, LINQ has an interface in Visual Studio that generates the entity classes from the tables in the database. However, in my application...

asked by 15.04.2016 / 00:29

2

answers

SQL conversion to LINQ C #

How do I convert the last row of this SQL to LINQ? SELECT* FROM ACOMPANHAMENTO A, PRESOS_ACOMPANHAMENTO PA, PRESOSS P WHERE P.ID_PRESOS = 300 AND...

asked by 07.12.2016 / 17:08

2

answers

Add subitems between groups with linq

How can I perform calculations between subitems of a group by query in linq? Here's an example: Linq Query var listPlanoDeContas = (from t in _planoDeContasRepository.GetAll() orderby t.Month ascending...

asked by 23.10.2018 / 18:56

Questions tagged as 'linq-to-sql'