Questions tagged as 'entity-framework'

2
answers

Batch deletion using Linq

I have a table, which is used in my Model.edmx , with the following fields: ID ID_PROJETO ID_ITEM VALOR How to convert the SQL below into a Linq expression? DELETE FROM TB_RECEITA WHERE ID_PROJETO = 100 AND ID_ITEM = 5     
asked by 05.01.2015 / 21:03
1
answer

Replication of database in WPF + EF system

I have a sales system in WPF / EF that is in use in different cities, but the database is in headquarters. I'm having trouble when the city link is too slow, resulting in a slow sale. Can I do a replication of this my database to the local se...
asked by 05.03.2015 / 14:01
1
answer

Use table of the Database, instead of table created when using Individual Authentication with Identity

I created an application in Asp.net MVC using Identity and I left checked the option for Visual Studio to create the authentication of individual users for me. It turns out that I just discovered that it creates a .mdf file that contains a datab...
asked by 03.10.2014 / 21:25
1
answer

Load records from different tables as anonymous type entity framework

How can I load multiple table data in the Entity Framework? By RAW Query I get normal, but by the Entity Framework I'm not getting to the point. What do I need to select the last entry that contains a specific product (I will pass the...
asked by 29.08.2014 / 15:48
1
answer

Procedure with out parameter (SYSREFCURSOR) with Entity Framework

I have a problem that is making me sleepy. I am performing a database migration, from SQL Server to Oracle, in a C # application. The above application is using the Entity Framework to access the database. I have been able to migrate the data...
asked by 21.10.2014 / 20:35
1
answer

How do I put a count in a linq that returns a list

I need to make a count , for the following situation. See the image below, which I have repeated some pharmacies, see their CNPJ (06626253003681 and 06626253001476 ). They are repeated because they are on different dates. What I need is t...
asked by 24.09.2014 / 20:43
1
answer

How to receive unique data in asp net mvc

I have the following model called Conta : public int Codigo { get; set; } public string Nome { get; set; } public int Prazo { get; set; } Assuming I want to do a select (without using lambda) and just bring the Name property, in this...
asked by 04.07.2014 / 15:42
2
answers

When concatenating in LINQ I get error

I made this LINQ. In the concatenation between DDD and phone number, which I call phone1, it is flicking. var agendamento = ( from pdv in db.T_PDV from tarefa in db.T_TarefaParceiro.Where(trf => trf.CNPJ == pdv.CNPJ).DefaultIfEmpt...
asked by 16.06.2014 / 20:54
1
answer

How to correct the error: Schema specified is not valid

I modified the DB for my project and did the update of my edmx file, but now when I try to compile the error is appearing:    No Entity Framework provider found for the   ADO.NET provider with invariant name 'MySql.Data.MySqlClient'.   Make s...
asked by 31.05.2014 / 23:44
1
answer

Entity connection name is out of standards

Whenever I change the database, I need to delete edmx and re-create it since update from database is not updating. So far so good. Whatever happens now he has created a connection with the totally non-standard name. It looks like this: win-mds...
asked by 27.05.2014 / 15:19