Get list of tables (objects) from Entity framework model (edmx)?
How to get list of tables (objects) from Entity framework model (edmx)? In LinqToSQL model, it's easy context.Mapping.GetTables(), but how in EF.. ...
entity-framework
Textbox with autocomplete
Hi there, Im programming with Visual Studio 2008 and making a web application using .NET Framework 3.5 with C#. All DAL linked with an powerfull entity framework wrapper (similar to the one that VS.net 2010 would use.) I'm having a textbox used for a search on first and lastname. That problem i'm having, it's that i'm using AJAX Control ...
Showing partial class properties in Entity Framework designer
Does anyone know if there is a way to add a property to a my partial class that will show in the Entity Framework designer so I can use it in my mapping to a stored procedure? I can modify the edmx, but would prefer to avoid it. ...
Entity Framework 1 Vs. Normal SQL app.
Does anyone know if there's a speed difference between a query with Entity Framework instead of SQL normal application? With entity Framework, we must manualy handle joins between tables and to my eyes, it seems like a fairly complex query. Given a customer with many joins on State/Province, Orders, Gender, Comments, favorites products,...
Does the Entity Framework have an equivalent of DataContext.GetTable<TEntity> from Linq2Sql (ObjectContext.CreateQuery<T>?)
Hi, I'm looking for an equivalent of the DataContext.GetTable<TEntity> in Entity Framework. I've found the ObjectContext.CreateQuery<T> method but it is different from DataContext.GetTable<TEntity> since it needs a querystring to work. Is there a way to get an IQueryable object for a table using the entity type without specifying the qu...
Convincing a die hard DBA to use an ORM for the majority of CRUD vs Stored Procedures, View, and Functions
I have been working with NHibernate, LINQ to SQL, and Entity Framework for quite some time. And while I see the benefits to using an ORM to keep the development effort moving quickly, the code simple, and the object relational impedance mismatch to a minimum, I still find it very difficult to convince a die hard SQL dba of an ORM's stre...
Entity Framework with a game server
I have been looking into using the Entity Framework in my C# game server to make querying easier. I am a huge fan of type safety, and the Entity Framework does a great job at automating most of the boilerplate code. Though I am not quite sure how to go about utilizing some of the components, namely the ObjectContext. The server uses qui...
Does the using the entity framework put a lot of pressure on memory, like the DataSet does?
I'm new to the entity framework. Some screen casts I've been watching, show results sets being held in memory with their changes. This seems like it could use a lot of memory. Does this mean that EF isn't suitable for ASP.NET development? Does the entity framework have a memory efficient pattern similar to the SqlDataReader? ...
Getting Entity Framework to update both normal and relational fields
Hello, I have a problem figuring out the proper way to get foreign key fields to update using the Entity Framework. I do not have a problem updating them in the database, but rather on the interface. Here are the relevant tables to my question file:///C:/Users/Mike/Desktop/RelevantTables.bmp I have a "Team" form with a Master/Detail ...
Adding additional entities to a Entity Framework backed Domain Service
We're investigating using RIA Services (July 09 Preview) to expose parts of an existing EF model. We've added a Domain Service class to our web application and specified the EF model to use and selected a few of the entities we wish to make available via the domain service (some have editing enabled, most do not). We build and everythi...
c# Adding a new object to an object context returns "error occurred while updating the entries", duplicate entry for primary key
I'm having a problem trying to add an object to an object context in Entity Framework. Here is the code : //related object ids are retrieved from another context. //since I thought the problem could be linked to object loaded in this context, I tried to //close it and start on a fresh object context... int idetab = currentEtab.Id; lon...
VS2010 MVC and Entity Framework Model in Separate Project
Hi I'm experimenting with ASP.NET MVC in VS2010. I'm trying to use an Entity Framework model in a referenced project within the main MVC project. However, although I can manually create a view that can work with the EF Model in the other project, I can't use the in-built scaffolding features. Is there something I'm doing wrong? For re...
How can I Inject Behavior into Entity Framework Object Constructors?
If I have an entity EntityA, which is an Entity Framework object, how would I go about injecting different behavior at time of creation? These particular entities need to utilize a different strategy for some calculations. I would like to use DI to supply the correct strategy when the object is created. Is there any way to intercept? A...
Using UDFs in Entity Framework
Is it possible to use user-defined functions (UDFs) in Entity Framework? Would it be possible to use them through stored procedures and then add them to the model? As far as I know it's only possible to use select stored procedures through Function Imports if they return an entity - correct me if I'm wrong ;-) ...
Entity Framework Associations
Hi, I've created a Model with Entity Framework from three database tables: Agents AgentsGroups Groups AgentsGroups is a simple table with three columns: 1 id and two foreign keys linking Agents and Groups (every Agent can have multiple Groups). Pretty basic stuff. Entity Framework correctly recognizes the relationships between the ...
ASP.NET MVC - EntityFramework and Binding to a List
I am currently using the EntityFramework to bind my ASP.NET MVC project to a MySQL database and one of my entities, Product, has an Images property containing a collection of ProductImages. I have built a form to allow the user to modify a given Product and this form includes fields for editing all of the images associated to that Produc...
Update query with entityframework
How to write an update query in EntityFramework using LINQ to Entities? EDIT: And if it is possible how this query can be written in Entity SQL? ...
.NET 4.0 CTP and EF CTP - is it good enough for production code?
I'm very interested in using 4.0 framework and also the Entity Framework 4.0. Currently .net 4.0 is in CTP and I'm EF 4.0 is in CTP Preview. I will not be coding for a few more months, but i'm not so sure that either .net 4.0 or EF 4.0 will be RTM by then. My questions: 1) Regarding Microsoft Products, is CTP usually stable enough ...
Testing Java database entity classes
Currently we are testing out entity classes and "worker" classes by writing java servlets for each entity and doing Insert,update,delete,find... for each entity to ensure that it works. The worker classes are simply implementations of an interface that persists the entity to the database using JDBC, they do the DB work for the entity. W...
Entity Framework System.Data.Mapping.Update.Internal.UpdateTranslator.Update
I have created this POC project in my dev machine with SQL 2008. I moved it to an other test server which has SQL2005 and I get this error: System.Data.Mapping.Update.Internal.UpdateTranslator.Update I have DateTime columns which I changed them to smalldatetime and format them correctly when inserting/updating. Has anyone see this error ...