I'd love to use data services to publish read only data over http. What I'd really like is the ability to provide different shaped bits of xml that represent whats in my db using filters, expand etc. What I don't really like is the 'goop' in atom, I know that json is a bit lighter but what I'd really like to do is whack in my own seria...
I am trying to create a new instance of a Customer entity in our application, and I am having a few problems. This entity has several navigational properties, each of which has their own nav. properties. For example, each Customer entity has an Address entity, and each Address entity has a Phone Number entity etc. I haven't figured ou...
I have a Windows Service which exposes three sources of data via ADO.NET Data Services. These sources of data are read only XML files loaded into an XDocument and then exposed via .AsQueryable(); The sources contain fields with integer IDs which can be considered to be 'foreign keys' between the data sources. My client consumes this dat...
In Linq2Sql you can connect a data context to multiple databases by just adding the database name to the source. Is there a way to achieve this in Linq 2 Entities / ADO.net Entity Framework? Can the database name somewhere be added to the table name? I tried to change the 'Schema' from dbo to MyDatabase.dbo, but the EF encapsulates thi...
I am encountering a weird error when using linq-to-sql with ado.net data services. I have a simple silverlight application that connects to a remote database. I first added the linq-to-sql class and dragged a table onto the designer. Then I added a ADO.NET Data Service, updated the DataService reference to point to the L2S Data context. ...
I want to expose a simple set of blog posts, tags and categories through an API provided by ADO.NET data services. It looks easy in the demos: create your entity data model using the entity framework designer, add in the data service, point it to the entities, done. So far so good. But some posts, tags and categories are unpublished (p...
I'm confused. I've got a Silverlight project that currently runs and displays a list of servers from my mocked model (I am following the MVVM pattern). The interface is coded as follows: public class GetServersCompletedEventArgs : EventArgs { public Exception Error {get; set;} public IEnumerable<LicenseServer> Results {get; pr...
Hi, I am using silverlight client with ado.net dataservices on entity framework. I have an Entity Contact and an Entity Address which is related with a foreign key relation ship... A contact can have 1 or more Adresses but a Address needs always at least 1 contact.. pretty basic... I have a Repository for my contacts and Address which...
I’m attempting to use ADO.NET Data Services to update my database. Tables: Person( PK PersonId; FK EntityRootId) EntityRoot( PK EntityRootId, FK EntityTypeId) EntityTypes( PK EntityTypeId) I’m trying to create an EntityRoot (unfortunate name since it may be confused with Entity Framework’s Entity. EntityRoot is in my domain) and ad...
I have a question that I'm struggling with in ADO.NET Data Services: When assembling an Entity for storage I need to get a related value from a lookup file. For example a person has a status code assigned of 'Pending' which is in a table called StatusCodes. In Entity Framework, I'd need to set the value of person.StatusCode equal to a...
ADO.NET Data service is the next generation of data access layer within applications. I have seen a lot of examples using it directly from a UI layer such as Silverlight or Ajax to get data. This is almost as having a two tiered system, with business layer completely removed. Should DAL be accessed by the Business layer, and not directly...
Hi ADO.NET Data Services looks very cool, and I would love to use it with a jQuery backed ajax website. Do any of you great people here on StackOverflow know of a jQuery plugin that will ease the CRUD operations against an ADO.NET Data Service? Regards, Egil. UPDATE: It turns out that the ASP.NET AJAX 4.0 (currently in preview 4) has...
I am considering using ADO.Net Data Services in a project for the purpose of getting data over to a Silverlight client. I'd like to use the Data Services with my existing Linq To Sql classes and designer. I probably could regenerate everything as ADO.Net entity objects, but I feel this would be a bad design for DRY reasons. I'm new to...
I'm pulling my hair out on this one. I'm trying to implement a ADO.Net Data Service that uses a Linq to SQL data context. I thought I had it working, but the URL for one of my tables always gets an exception. The obvious difference between the table that isn't working and the ones that are, is that the one getting the exception is usi...
Console application var result = dataService.CreateQuery<Customers>("GetCustomerByLastName"). AddQueryOption("lastname", "S"); Service [WebGet] public IQueryable<Customers> GetCustomerByLastName( string lastname ) { return from c in this.CurrentDataSource.Customers where c.LastName.StartsWith(...
Hi Lets say I have a lists of entities (for example, a list of TODO items) that more than one user can change, delete from and add to at the same time. So to maintane a synchronized listed between all the clients, I want each client (AJAX based) to ask for changes every xx seconds. Since the list can get veeery long, I do not want to d...
I'm using ado.net data services and want to implement row level security in the query interceptor to limit the data to only return data that the user is allowed to see. The complexity comes in in that the user name for the the user is on another table. So I thought I could retrieve a list of events that the user can see according to the ...
What is the best way to secure ADO.NET data services? Has anyone used this in production, if yes what security options have you used? ...
I have a silverlight client accessing data through ado.net data services. One of my queries has a number of expand clauses, and gets back quite a number of entries. The xml response is enormous, and I'm looking for ways to make this more efficient. I have tried: Paging (not an option for this behaviour) Http compression (some client ...
We're using query interceptors in ADO.NET Data Services in our application to filter the result set for each entity based on the data that a user has access to. However I'm getting the following exception thrown from one of our query interceptors: Internal .NET Framework Data Provider error 1004, 0, Related Entities cannot be specified...