Same as Title.
Has anyone found a way to make the ADO.NET Entity Framework work with OLE DB or ODBC data sources? Specifically, I need to work with an SqlServer2000.
Hi there,
I have a stored procedure called 'GetPrices' with a Table-Valued Parameter called 'StoreIDs' and I would like to call it from my Entity Framework. But when I try to add the Stored Procedure to the EDM, i get the following error:
The function 'GetPrices' has a parameter 'StoreIDs' at parameter index 2 that has a data type 'table type' which is not supported. The function was excluded.
Is there any workaround this? Any thoughts?
Fabio
In my code I'm attempting to use a transaction using TransactionScope with Entity Framework. While in this transaction we are opening a regular SQL connection to a seperate server and database. When the conn.Open() is called we get an
Error:
"Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Componet Services Administrative tool."
However, MSDTC is enabled and running on the Server.
Hello,
I'm writing a standalone application and I thought using Entity Framework to store my data.
At the moment the application is small so I can use a local database file to get started.
The thing is that the local database file doesn't have the ability to auto generate integer primary keys as SQL Server does.
Any suggestions how to manage primary keys for entities in a local database file that will be compatible with SQL Server in the future?
Thanks,
Ronny
I have an entity context that includes three tables (see diagram here). The first is a table that contain products, the second contains recipes. The joining table has fields for IDs in both the products and recipes table as well as a 'bit' field called 'featured'.
I've searched and found no example on how to insert only how to select against this type of scenario.Does anyone have any suggestions on how this can be done? Thanks in advance for any help.
Cory
Order by descending is not working on LINQ to Entity
In the following Query In place of ascending If I keep descending it is not working. Please help me out
var hosters =
from e in context.Hosters_HostingProviderDetail
where e.ActiveStatusID == pendingStateId
orderby e.HostingProviderName ascending
select e;
return hosters.ToList();
We are using Entity Framework 1.0.
In some cases we need to explicitly open connections, and then need to explicitly close connections. See http://msdn.microsoft.com/en-us/library/bb738582.aspx
My question is, when we call "close" does the connection actually get closed, or is it just returned to the connection pool?
I'm investigating the use of Entity Framework in an upcoming project, but I have some concerns about the maturity and market adoption of the product. Are there any high profile web sites or applications using the product? Are there any significant open source projects that have picked it up?
I have a problem when I add an entity object with ObjectContext.AddObject method because I can't retrieve that object with LINQ querying my ObjectContext.Person entities. I know that this new added object is stored somewhere, because it is used to update database after SaveChanges method. That's bothers me because I want to update my datagrid DataContext without saving changes unless I really want to do it. It doesn't help if I add the same object to DataContext list myself directly.
Hi,
I use Entity Framework V4 and i want to update Customer who have Visits.
My code :
EntityKey key;
object originalItem;
key = this._modelContainer.CreateEntityKey("Customers", customer);
if (this._modelContainer.TryGetObjectByKey(key, out originalItem))
{
this._modelContainer.ApplyCurrentValues(key.EntitySetName, customer);
}
this._modelContainer.SaveChanges();
It works for Scalar Property only. The customers.Visits collection is not updated.
Best Regards :)
My requirement is to create an Enum based on values present in a table from DB. I am using ADO.NET Entity Framework model (.edmx file), Can any one of you help me out...
Thanks,
Vinni
I am using VS 2010 Express.This error appear "Error HRESULT E_FAIL has been returned from a call to a COM compenent" When i try to Add ADO.NET Entity Data Model. VS 2008 PRO is installed on my pc too but i don't think that it is caused by VS 2008 .I tried to reinstall VS 2010 Express but still same. How can i fix it ?
Hello,
In What scenario that I have to use DTO's pattern in the entity framework the and not the Self Tracking Entities pattern?
Can I start with Self Tracking Entities because it's easier to develop and then add DTO's in the next Phase ???
As always, your advice is greatly appreciated...
Hi!
I have installed Visual Studio Team System 2008 Architecture version: 9.0.30729.1 SP and Microsoft Net Framework 3.5 SP1.
When I'm going to add a new item I can't find ADO.NET Entity Data Model template.
What's happening?
Thanks!
Hello, I have two tables that are connected via a join table in a many-to-many relationship in the Entity Framework. I need to add a composite primary key in the join table for the two columns that are related to the joined tables via standard foreign keys but I'm sure how to do that.
Suppose I have
table Person
table Employee, which inherits Person.
I want to get a list of Person only. How do you get entity framework to do that without joining the Employee table?
I need to be able to do
select * from myTable with (xlock,holdlock)
from Entity Framework. Is this possible? I've opened a TransactionScope with the Serializable isolation level but my selects are not locking the tables. I'd like them to lock until I complete the transaction scope.
Hi, I currently have the following MySQL statement to replace the HTML entity for a single quote with an actual single quote:
update photo_galleries replace(title, ''', '\'');
This statement returns an error. I have tried adding additional backslashes, but this does not help at all. I want to run this command using pure SQL (no PHP, etc.). Any suggestions are welcome and appreciated. Thanks.
I attempted to add a ADO.NET Entity Data Model to my Visual Web Developer 2010 Express project and it generates but returns a whole slew of errors. Why is this generating errors? Here are the main errors:
'Public Property ID As Integer' has multiple definitions with identical signatures.
Method 'Onaddress_IDChanging' cannot be declared 'Partial' because only one method 'Onaddress_IDChanging' can be marked 'Partial'.
'_line1' is already declared as 'Private _line1 As String' in this class.
Hello, is there any sample projects that I can download that shows alot of interaction with the entity framework and the mvc pattern of asp.net?
It should have stuff such as:
CRUD
CRUD on child records
Relationships
Inheritance
Thank you.
Hi Everyone
Is it possible to create the database from the classes with entity framework 4.0? I found many tutorials on how to do it the other way round. But since we have already implemented and tested all classes of the domain we'd like to avoid changing them to much.
If I used the wrong keywords in Google I'd appreciate you could post a link.
Cheers,
CA
Hello
I wanted to know if there are any paid or free named entity recognition web services available.
Basically I'm looking for something - where if I pass a text like:
"John had french fries at Burger King"
It should be identify - something along the lines:
Person: John
Organization: Burger King
I've heard of Annie from GATE - but I dont think it has a web service available.
Thanks
I had to get a new machine recently. It is Windows 7, loaded with Studio 2008, with Framework 3.5 sp1. When I load pre-existing projects that use the Entity Framework, the projects don't recognize the .edmx files. Any ideas?