ado.net-data-services

ADO.NET Data Services and Custom Data Source

I have a Business Logic Layer (BLL) and a Data Access Layer (DAL) that used for WinForms, WebForms, and ASP.NET MVC projects in the past. The objects implement all kinds of interfaces. Now I would like to tackle ADO.NET Data Services. I am trying something simple like the following, but it's not rendering my service. Am I totally m...

Mocking a DataServiceQuery<TElement>

How can I mock a DataServiceQuery for unit testing purpose? Long Details follow: Imagine an ASP.NET MVC application, where the controller talks to an ADO.NET DataService that encapsulates the storage of our models (for example sake we'll be reading a list of Customers). With a reference to the service, we get a generated class inheritin...

Hitting a ADO.NET Data Services from WPF client, forms authentication

Hey all! There are a number of questiosn on StackOverflow that ALMOST hit this topic head on, but they are either for other technologies, reference obsolets information or don;t supply an answer that I can suss out. So pardon the almost duplication :) I have a working ADO.NET Data Service, and a WPF client that hits it. Now that they a...

ADO.NET Service update error

I have a very simple exercise on ADO.NET Service: Put the list of Product in a list box, when selection changed in the list box, display UnitPrice and UnitInStock in two textboxes. Then change the data in textboxes and save the changes. Here is all code for at client side: namespace TestApp { public partial class Form1 : Form {...

When to use WCF and when to use ADO data services in ajax websites?

I am really confused about when to use WCF and when to use ADO data services in my website ajax calls. I always make my javascript code call a webservice to get data from server "ajax". But while reading in both WCF and ADO data service, i am not sure when to use each and when not use?, and if they replace each other in my case? or can...

Creating a custom property in Entity Framework

I have a database I'd like to create an entity from, and then generate RESTful output. My objective is to add a property to one of the tables once it becomes an entity. The data for that property would be one I'd come up with through calculations done on a few different fields in the table. From there, the code generator would create ...

Silverlight 3 Architecture and implementing DataAnnotations - Adivce

I am uisng Silverlight 3 and ADO.NET Data Services with a cusotm-built Model (separate project) and DAL (separate project)) in place. Within my Silverlight project, I create a [Service Reference] that references my .svc file that in turn points to my Model. Here's my question: I would like to use the rich features of DataAnnotations ...

What should I know about working with ADO.Net Data Services? (FAQ)

I've been learning by doing with ADO.Net Data Services (Astoria) for the last couple of months, and while I like the technology the learning has been a real trial. Information that you need to use them effectively is spread over MSDN documentation, articles, blog posts, support forums and of course StackOverflow. This question is a place...

What is the difference between writereplace & writeMerge in Ado .net data service?

I am configing ado.net dataservice in public static void InitializeService(IDataServiceConfiguration config) { // config.UseVerboseErrors = true; // TODO: set rules to indicate which entity sets and service operations are visible, updatable, etc. // Examples: ...

Consuming Service Operations of an ADO.NET Data Service from a .NET Client

I am trying to build an ADO.NET Data Service with lots of entities and a few service operations. On one side I created a ASP.NET Web Application, in which an ADO.NET Entity Data Model and an ADO.NET Data Service are located. On the other side I created a second ASP.NET Web Application that has a Service Reference to the Data Service. En...

ADO.NET Data Services querying against LINQ to NHibernate: "Could not understand: (IIF(([1003] = null), null, Convert([1003].Contains("name"))) = null)"

I'm trying to perform a simple query using ADO.NET Data Services running against LINQ to NHibernate. I can execute this query var query = _context.CreateQuery("FileDTOs") .Where(file => file.Name.Contains("name")); I can run a similar query directly against LINQ to NHibernate without issues, but when I pass the same q...

ADO.Net Data Service Operation: Array of integers as a parameter

This question is a bit of a two parter for .Net data services. This is the function signature I'm trying to achieve: /// <summary> /// Returns Descriptions for any asset in the given assetIDs. /// </summary> [WebGet] public IQueryable<Description> FindDescriptionForAssets(int[] assetIDs); I'm trying to create a custom service operat...

Can I use ADO.NET Data Services with a LINQ-to-DataSet data source?

We have an existing application that relies heavily on stored procedures and untyped DataSets. I'd like to maintain that flexibility, but leverage the REST capabilities of ADO.NET Data Services. However, when I attempt to use the following code to expose the DataSet to ADO.NET Data Services: namespace NewTechnologyDemo { public class ...

ado.net data services silverlight security

I have a application where the validation is done in the web server side (in the page). and the control is passed to the sl client. The SL client makes call to the ado.net data services for its query and wcf service for writing to the DB. How should I handle the security of the ado.net data services? I use http://programmerpayback.com/2...

AtomPub - What's your recommendation?

I'm looking to create a service (based on .NET Fx 3.5 or 4.0) that exposes data via Atom and enables AtomPub (so that I can update using Windows Live Writer). There looks to be two options: Use ADO.NET Data Services. From what I can tell this is the easiest to get working, but requires EF (I'm using LinqToSQL - although I know there ...

How do I implement IDataServiceMetadataProvider and tell my Data Service to use that custom provider?

There's no obvious entry point for implementing a custom provider for an ADO.NET Data Service using IDataServiceMetadataProvider, and then telling a Data Service to use that provider. Has anyone had any luck in this area? I've tried implementing this interface on my Data Source class, but none of my breakpoints are hit. There is also no ...

Data compression for ADO.NET data services

I have an ADO.NET data service exposed by a .NET app (not IIS) which is consumed by a .NET client app. Some calls to this data service return large amounts of data. I'd like to compress the XML data on the wire to reduce payload and improve performance. Is this possible? ...

Where can I find information on creating a WCF Data Services Custom Data Service Provider?

Our team is evaluating using WCF Data Services (formerly ADO.NET Data Services), and have determined we'll have to create a Custom Data Service Provider. Where can we find a sample implementation of the two required interfaces: IDataServiceMetadataProvider and IDataServiceQueryProvider? EDIT: Note that a "WCF Custom Data Service Provid...

ADO.NET Data Services - Uploading files

I am trying to write REST web service through which our clients can upload a file on our file server. IS there an example or any useful links which I can refer for any guidance? I haven't seen many examples of POST operation using ADO.NET data services available. ...

Can I (safely) use the ThreadStatic attribute in ADO.NET Data Services?

I want to store per-thread data in an ADO.NET Data Service. Is it safe to use the ThreadStatic attribute on my thread-specific static variable, or will I run into problems? My concern is that my ThreadStatic variable(s) won't be garbage collected after the request is completed and the thread dies. If there's a better way to do what I'm...