Horrors, I'm stuckk with only 3G access to the net, so I would like to download some solid references to Entity Framework and Dynamic Data that I can get by with while offline, as I'm no expert on these. ...
Hello, In ADO.net EF, when should you call the context.Attach() and the context.Detach() methods and how do these calls affect the data being returned or being inserted? ...
The title says it all really. I want to use Entity Framework for my data access on a project I'm writing in Visual C# 2008 Express Edition. Can it be done? What do I need to know? Update: My question has been answered, so thanks. As a followup, can you use a visual design tool or are you stuck with the EdmGen.exe command line tool? ...
I'm trying to sort a list of entities using a GridView in ASP.NET, but I can't seem to get it working following examples. I have a property called Name on my entity, and I'm trying to sort by a specified column if given, or the Name column if the sortExpression is empty. public static List<Product> GetProducts(int startRowIndex, int max...
Hi, i must be doing something wrong or maybe i don't get this. I'm trying to fill 'PropAllMenus' (that has a bunch of properties) with data coming from my entity framework. However, when doing the conversion trough a function i get a 'InvaldCastExeption' in my 'WeekMenuRepository'. Here is the code: PropAllMenus Public Class PropAllMen...
My EF model was generated from my SQL Server database. I then generated a DomainService for RIAServices against the EF model. One of the entities is called "EntryCategories". The DomainService created this method: public IQueryable<EntryCategories> GetEntryCategoriesSet() { return this.Context.EntryCategoriesSet; } Since my user i...
I'm sure this is straight forward but I'm very new to entity queries and has probably been asked before. What i need to to search for all business in my database where they have a category that exists in a collection of categories I have built up IList<businessCategory> busCatList; busCatList.Add(businessCategory.CreatebusinessCategor...
I want to read the excel sheet file and convert to xml file. How can I do this in entity framework ...
I cannot find any examples on how to do a Bulk/batch insert using Linq to Entities. Do you guys know how to do a Bulk Insert? ...
In my SQL Server database schema I have a data table with a date field that contains a default value of CONVERT(VARCHAR(10), GETDATE(), 111) which is ideal for automatically inserting the date into the new record when manually entering records in to the database. The problem I have is that when using the Entity Framework and mapping ...
We are using LINQ to EF to develop a solution. In my LINQ query I would like string toMatch = "Matt Cool"; newString = toMatch.Replace(" ", "% ") + "%"; // So here newString is 'Matt% Cool%' /*Now in my datasource, there is no 'Matt Cool', there's 'Matthew Coolguy'. I would like this query to return that result. I would expect th...
So, I'd like to know how many results I'll be getting back from a RESTful uri GET request. I don't know of any way to do that at this point. Is there a way to do that? Since REST just throws out properties, I don't know if it is able to take a count of its results, but it can skip results and take a subset of results. Anybody have ...
I'm using the EF to try to update an entity with ASP.NET. I'm creating an entity, setting it's properties then passing it back to the EF on a separate layer with the ID so the change can be applied. I'm doing this because I only store the ID of the entity when it's been bound to the UI controls. Everything works for standard properties,...
I'm using VS2010 Beta 2, I have a Complex Type called Address with the following properties: Street City CountryId I have a Country Entity defined in my Model, but I can't seem to find a way to add a reference (Navigation Property) from the CountryId property of my Complex Type to the Id property of my Country entity. I'm I going ab...
Hello, I've been wondering for some time if there is any way in Entity Framework to save some changes to the database and others not. Imagine a situation in which I have let's say 4 entity classes - Customer, Task, SalesSchema and Address. Each of those is a customers one-to-many relationship. Now I create a window with 3 tabs (using Tab...
Is it possible to refresh only one entity in entity framework designer? Every time I refresh model from database, it refreshes all entities. The problem is that this mechanism doesn't recognize properly primary keys in views, so I have to correct it manually. Am I missing something? ...
I'm currently learning a bit more about Linq-To-Entities - particularly at the moment about eager and lazy loading. proxy.User.Include("Role").First(u => u.UserId == userId) This is supposed to load the User, along with any roles that user has. I have a problem, but I also have a question. It's just a simple model created to learn a...
Can you recommend a good Entity Framework book? I'm interested in using Entity Framework in a layered application so I would like a book that deals with such a scenario. ...
Right now i'm doing some tests involving entityFramework and WCF. As I understand, the EntityObjects generated are DataContracts and so, they can be serialized to the client. In my example I have a "Country" entity wich has 1 "Currency" as a property, when I get a Country and try to send it to the client, it throws an exception saying t...
I will be using Linq to Entities. The question that I have is, I will be calling Linq to Entities multiple times. Will Linq to Entities queries be cached will it is called several times? If not is there a way to cache the query so it is not compiled or generated every time it is called. ...