Most voted "entity-framework" questions
ADO.NET Entity Framework is a set of tools for object-relational mapping or Object-Relational Mapping (ORM) for the . NET Framework by Microsoft, Since version 3.5 SP1.
Learn more…1,214 questions
Sort by count of
-
2
votes2
answers98
viewsDropdown - ASP.NET MVC
I’m a beginner in ASP.NET MVC and I need to create a Dropdown in a vehicle registration form where I can choose only one driver related to the vehicle that is previously registered in the database…
-
2
votes1
answer132
viewsRelationship one-to-Many Entity Framework
I am developing a crud of registration for a project. When registering the user(Employee) must inform a IdCity that is related to the table cities(Cities). How is it possible for me to automatically…
c# asp.net-mvc .net entity-framework entity-framework-6asked 5 years, 7 months ago vinilazzari028 23 -
2
votes1
answer205
viewsTwo error connection in the Entity Framework class constructor?
I need to use the connection to two databases, using Entity Framework, on appsettings.json, I added this way: "ConnectionStrings": { "banco1": "caminhobanco1", "banco2": "caminhobanco2" }, and in…
-
2
votes1
answer52
viewsBest way to query the database using LINQ and Entity Framework
Hello! I need to make a query in the database, the scenario is as follows: I receive email and from it I seek the id user. About the bank, there is the table Contact, which has Nxn relationship with…
-
1
votes1
answer97
viewsHow do you model 1x0 relations. 1 (optional one-to-one) in the Entity Framework Code First?
When an Entity CAN have one (and only one) instance of another Entity, but the second entity must have the first, as the Entities modeling is done?
-
1
votes2
answers808
viewsScaffolding ASP.NET giving error
The error is generated using VS 2012. When I try to create the Controller for my News using the Entity framework, I have tried several ways. o My database you can see in the server explorer on the…
-
1
votes1
answer328
viewsSomething wrong with references using two layers in Entity
I made an example in Entity 5.0 and with 1 layer worked perfect. Now I’ve separated into UI and DAL, but this giving error. The same page that worked in the layer DAL when made in the UI is giving…
-
1
votes1
answer208
viewsController and View Structure
A help not to do something much more laborious than it can be right away. I have the following classes in my Model: public Pessoa { public int Id { get; set; } public int TipoPessoaId { get; set; }…
-
1
votes1
answer120
viewsRun Trial with Codefirst
I am trying to run a trial on ASP.NET MVC with Codefirst. I saw some examples on the internet but they are not working, someone can help me? Follow the code I’m using, the Procedure just copies some…
-
1
votes1
answer1953
viewsDynamic Linq Query between two contexts
I’m trying to return the query sql sequinte but without success. SQL= select IDEstado, COUNT(IDEstado) from PessoaEstado w join Nucleo.dbo.Estado e on e.ID = w.IDEstado where IDPessoaMaster = 46…
-
1
votes1
answer62
viewsI can’t get into the comic book with Entity
This is my input code. Why is it wrong? What should I do? public int abreOsParceiro(string os, string cnpj, string dataAbertura, string dataVisita, string tecnico) { WEBEntities db = new…
-
1
votes1
answer70
viewsConnection name with Entity is out of standard
Whenever I change the database, I need to delete edmx and recreate it, because the update from database is not updating. So far so good. What happens is that he has now created a connection with the…
-
1
votes1
answer262
viewsEntity framework does not create mdf file
In my ASP.net MVC5 project he creates the default database by Visual Studio 2013. I went to the App_data folder and deleted the database mdf file, as well as the log file. I’m wanting him to create…
-
1
votes0
answers53
viewsPage a very large list
Grid in MVC - I have a lot of data to return and I didn’t want to bring all of a single see even why there is paging. How do I get 10 records? Which grid to use together with MVC and Entity…
-
1
votes1
answer55
viewsHow to pass a string value to a type in the Entity
In my Entity mapping, the fields that are FK got like this: public virtual T_Acao T_Acao { get; set; } public virtual ICollection<T_OsParceiro> T_OsParceiro { get; set; } public virtual…
-
1
votes2
answers104
viewsBatch 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 =…
-
1
votes1
answer2118
viewsHow to fix the error: Schema specified is not Valid
I modified the BD of my project and performed 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…
-
1
votes2
answers766
viewsRemove objects from memory
I have a DataGridView in my project and a timer with refresh 5 seconds. I realized that the system was overloading the memory, as each time I listed the previous data remained in memory. This is the…
-
1
votes2
answers6021
viewsButton/link inside a view redirecting to another view
I have the following address for a view: http://localhost/Configuracao/Details/1 Where create a button/link that redirects to another address from another view as follows: <a…
-
1
votes1
answer166
viewsDatabase replication in WPF + EF system
I have a sales system in WPF / EF that is in use in different cities, but the database is at headquarters. I am having problems when the city link is very slow, resulting consequently in the slow…
-
1
votes1
answer129
viewsIn the table Insert is inserting everything, until what I do not want
When I give a savechanges(), records to all tables and would like just one. How do I do? Tables Acao and ProximaAcao also inserts record. public T_TarefaParceiro geraIdParceiro() { WEBEntities db =…
-
1
votes1
answer111
viewsHow to always keep 1 record in BD after inserting with entityframework?
I am developing in . NET MVC using Entity framework, how do I save a data by consulting if there is record or not in the table? 1.Query whether or not there is any data in the table 2.If you have…
-
1
votes4
answers2214
viewsBring a Max(Date) with LINQ
I have this Linq: var resultado = ( from pdv in db.T_PDV from tarefa in db.T_TarefaParceiro.Where(trf => trf.CNPJ == pdv.CNPJ).DefaultIfEmpty() from parceiro in db.T_OsParceiro.Where(prf =>…
-
1
votes2
answers104
viewsWhen concatenating into LINQ returns error
I did this LINQ. In the concatenation between DDD and phone number, which I call phone 1 is giving dick. var agendamento = ( from pdv in db.T_PDV from tarefa in db.T_TarefaParceiro.Where(trf =>…
-
1
votes1
answer47
viewsIs it feasible to use datatable copyBulk for DBMS data loading?
I went through an experience in doing a large load of data from a text file, which needed to be criticized before writing to BD. I used Datatable with copybulk. I realized that the data load in…
-
1
votes2
answers1537
viewsjquery method does not pass parameters to controller
Jquery does not pass parameters to controller. Empty values. Jquery: function GravaEvento() { var str = ""; var parametros = jQuery.parseJSON('{ "DE_Cnpj": "' + $("#txtCnpj").val() + '" ,…
-
1
votes1
answer130
viewsHow 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 select (without using lambda) and bring…
-
1
votes1
answer541
viewsCustomizing Individual User Accounts
Well, I have an Asp.Net MVC web project that uses Individual User Accounts and I would like to use a specific table in my database and a different class to manage user login. How can I do this?…
asp.net-mvc sql-server entity-framework asp.net-identityasked 9 years, 10 months ago Jedaias Rodrigues 6,718 -
1
votes1
answer108
viewsSQL database for multiple users
Well, I have a question. I am developing a web application that will suit more than one user, however each user has different data recorded in the database, and this volume will be great, since the…
-
1
votes0
answers27
viewsPre-generated Mapping Views
I followed this simple instruction to create the Mapping Views: Always the first consultation at the bank takes so creation Mapping Right? That’s why the first delay? Right? I created it in the form…
entity-frameworkasked 9 years, 9 months ago Euripedes Barsanulfo de Araujo 81 -
1
votes1
answer442
viewsProblem with Mysql Connector
I am using MVC 3, Entityframework 4 and Mysql database. I hosted my application on Locaweb. Unfortunately, I can’t connect the same thing to the database. Running the application on my local machine…
-
1
votes1
answer152
viewsLoad records from different tables as Anonymous type Entity framework
How can I load data from multiple tables in the Entity Framework? By RAW Query I get normal, but by the Entity Framework I’m not getting to the point. What I need is to select the last entry that…
-
1
votes1
answer2030
viewsError adding Httppost to controller
I’m having a problem adding the attribute [HttpPost] on my controller. I mean, I can add the attribute without problems, but when I compile and go to the registration form I just can’t access. I get…
-
1
votes0
answers795
viewsLocaweb Publishing Error - ASP.NET with Mysql
I published a site on Locaweb: . Net + Mysql + MVC 4 + EF6 For more details of the error: http://locvip.tempsite.ws/ Detail: wheel location normally. But when I published it occurs the following:…
-
1
votes1
answer619
viewsHow to concatenate fields in the Line and rename
I made a Burst and it is not working concatenation and renaming it. See: var monta_arvore = (from rup in db.Ruptura from apr in db.Apresentacao.Where(ap => ap.Codigo_Apresentacao ==…
-
1
votes1
answer154
viewsMysql with Entity framework Code First ID skipping 10
I’m setting up a Mysql in the Azure for an application I’m working on, however while saving my records to identity column is increasing by 10 by 10. This would be an Entity adjustable setting or an…
-
1
votes2
answers672
viewsValidation model always fails
I have the following models: public class Local { [Key] public int Id { get; set; } public virtual Grupo Grupo { get; set; } } public class Grupo { [Key] public int Id { get; set; } [Required]…
-
1
votes1
answer118
viewsMake a foreach that does not repeat the same data
I have this foreach, in a table with more than 5000 records. There are only 6 types of business unit. I would like that in the foreach and Ingl, when a type of UN appears, it loads and then does not…
-
1
votes1
answer215
viewsC# set a condition for a column value in a Datagridview with Datasource
I’m using VS2013 Entity 5. The situation is as follows: In a table of Sons, there is an attribute sexFile that receives the value 0, 1. 0 for male and 1 for female. (could use "m" or "f", but it is…
-
1
votes1
answer196
viewsHow do I put a Count in a string that returns a list
I need to make a count, for the following situation. See the image below, that I have repeated some pharmacies, see their CNPJ(066253003681 and 06626253001476). They are repeated because they are on…
-
1
votes1
answer1316
viewsUse Database table instead of table created when using Individual Identity Authentication
I created an Asp.net MVC application using Identity and left checked the option for Visual Studio to create individual user authentication for me. Turns out I just found out that it creates a . mdf…
-
1
votes1
answer87
viewsReplacement for the Fluent API
I am in a project of a system that uses the C#language, using MVC, Entity Framework and I am using the Fluent API. I wonder if there’s another way to do it. HasKey(oc => oc.OrdemCompraId);…
-
1
votes1
answer238
viewsProcedure with out parameter (SYSREFCURSOR) with Entity Framework
I am having a problem that is keeping me awake. I am making a database migration, from SQL Server to Oracle, in a C#application. The application mentioned is using Entity Framework to perform…
-
1
votes1
answer67
viewsEntity Framework Navigation Property
I am trying to execute the following code, but it is giving error where it is trying to re-enter the state in my bank, however it was searched through another connection I know that a solution would…
entity-frameworkasked 10 years, 5 months ago Pablo Tondolo de Vargas 5,444 -
1
votes1
answer533
viewsHow to make a lambda in?
I have a function convertStringListaInt parameter String. Example : String: 1,2. I’m converting this string into a List of the kind convertStringListaInt_Result owned by number(whole). How can I…
-
1
votes1
answer1395
viewsEntityframework type conversion error: Cannot convert a 'System.Collections.Generic.Hashset`1[]' object
I am getting this error while trying to record a new record of Atendimento. Cannot convert an object of type 'System.Collections.Generic.Hashset`1[Domain.Servicesinexus]' in type…
-
1
votes2
answers601
viewsHow to use my already populated Firebird database for a web project in visual Studio 2015 using Entity framework?
I have an already populated Firebird database and would like to use this same database for a Web project in visual studio 2015. I already installed Firebird ADO.NET Data Provider and tried to give a…
entity-framework firebird connection visual-studio-2015 databaseasked 9 years, 2 months ago Victor Glauber 95 -
1
votes1
answer213
viewsHow do I use the service based database item in Visual Studio 2015?
I am taking an online course of Entity Framework in which the course uses Visual Studio in the 2012 Express version, and I am using Visual Studio Enterprise 2015. And during the course he asks to…
asp.net-mvc entity-framework visual-studio-2015 visual-studio-2012asked 9 years, 1 month ago Leonardo Gustavo Maran 93 -
1
votes1
answer146
viewsFilter search with Checkbox values
For example, the User typed the title of a publication, and marked the generous Action and Adventure, or the user did not type any title, but wants to see all publications that fit these genres. How…
-
1
votes1
answer32
viewsPagination with EF 7 Asp.net 5 MSQL 2008
Good morning I would like to know if anyone has any solution for paging using EF - Entity Framework for versions prior to MSQL 2012