I'm looking at using ADO.NET Data Services with silverlight. I've been looking at the Data Model and Data Service Implementations (ADO.NET Data Services/Silverlight) topic on msdn. In their example, they build a data model generated from a database, and query entities in the datamodel. In my case I want to use stored procedures, so I...
Consider following example: SQL Table Customer: ID: Primary Key Name: Name SQL View ViewCustomerSelection: ID: Link to Customer ID SomeOption: Not important I'd like to create ADO.NET an entity that only selects customers that have corresponding values in ViewCustomerSelection Following does NOT work: Create entity that maps to...
I have 3 tables (and corresponding entities in the entity model) Game: Id - primay key ... other columns Player: Id - primary key ... other columns GamePlayer (a player can participate in many games) GameId --> foreign key from Game PlayerId --> foreign key from Player ... other columns In my code, I have gameId and playerId available...
I'm working on my first .NET project (.NET 3.5, ADO.NET and C#). We've built our entity models and are trying to build a clean business objects layer. We've got our basic entity model and we want to add certain business-level semantics to the default data accessors (navigation properties, etc). For example, let's assume that we have a...
Hello comrades. I have a classical many to many scenario with three tables (students, courses, and third StudentsCourses assignment table). I'm using EF in my new project and EF designer doesn't create third table. I need to select all cources along with number of students assigned to it. Using plain SQL is very straightforward: selec...
We have a table that looks roughly like this: CREATE TABLE Lockers { UserID int NOT NULL PRIMARY KEY (foreign key), LockerStyleID int (foreign key), NameplateID int (foreign key) } All of the keys relate to other tables, but because of the way the application is distributed, it's easier for us to pass along IDs as parameters. ...
I need some help understanding the ADO.NET Entity Framework. I'm trying to represent and manipulate hierarchical data in a WPF TreeView control with the ADO.NET Entity Framework. Each of these Things has a single parent and zero or more children. My "delete" button... Private Sub ButtonDeleteThing_Click(...) db.DeleteObject(Di...
Can someone please outline the process of building a SQL Server Reporting Services 2008 report based on a ADO.Net Entity Framework Entity Data Model? If you know of any example, please point me to it. Thank you! ...
Hi, I need to use tables from a DB which I cannot alter (using linked server). So part of my schema is a view on these table and I cannot create an FK in my DB. When I come to creating the association in ADO.NET Entity Framework I am getting problems because a second column on the table from the external DB has an index on it and the EF...
In an ADO.NET Entity Framework object model, I'm running into some trouble with related tables. (Navigation Properties) My backend datastore is a SQL CE database. When I make changes directly to the related table, these changes don't show up through a higher level table ever after calling SaveChanges. My changes are saved perfectly ba...
(Playing around with the MVC framework) I have created a ADO.net Entity Data Model. Now I'd like to extend it with some business logic, like creating functions returning subsets of the context. A partial class is created together with the Data Model, so I created a new file declaring a partial class like this: I placed a function in it ...
Does anyonw know how to extend, i.e., add funcionalities to the Entity Designer in Visual Studio? For instance, I want to right click a property of an entity on the designer and have a new option on the context-menu that allows me to do any stuff I want. ...
I have in my Database a Contact table and a Phone table, in the phone table there is column "ContactId" with a key that references the phone to the contact. In the key options in the server I set its delete option to 'Cascade'. Now when I attempt to delete a contact using the context: Dim contact As Contact 'The contact I want to dele...
Is it possible to define primary and foreign keys for database Views in Microsoft SQL Server Management Studio? How? I'm trying to create an ADO.NET Entity Data Model to read from four old, poorly-formed database tables that I cannot modify. I've created Views of just the data I need. The four Views should map to a simple three-entit...
Consider two tables Bill and Product with a many to many relationship. How do you get all the bills for a particular product using Entity Sql? ...
Hi, I'm using the ADO.Net Data Model and would like to truncate any string that are over the database field's max length. I can see the info in the .edmx xml but I can't find it in C#. On save I'd like to truncate string so I don't get sql errors. I found this post but it uses Linq and I could not find the CustomAttributes in my co...
When trying to add a few items to the database I'm getting this error: UpdateException was unhandled by user code An error occurred while updating the entries. See the InnerException for details. The InnerException contains this: {"Column count doesn't match value count at row 1"} I can't see anything wrong with the objects...
I am using a Domain Service Class linked to a Linq-to-Sql Context. Using breakpoints it successfully Adds, context.Company.Add(NewCompany); Am calling this from Silverlight,but the saving part seems to fail... context.SubmitChanges(); As in, I get no errors, nor does it add to the database. All my tables have a relation to each oth...
Scenario I am playing MVC NerdDinner project and using ado.net entity data model instead on 'dbml' I have 2 database tables Dinner & RSVP where RSVP contains DinnerID as foreign key from Dinner table. Now when I am accessing a particular record from Dinner table, it returns a dinner object with RSVP property but there are no data with ...
Hi, Are you supposed to use one ADO.NET Entity Data Model for each table? Or one for your entire database where relationships are also routed, etc... ...