Monthly Archives: October 2008

ADO.NET Data Services Hooking POC V4

I don’t like rights management with ADO.NET Data Services. Indeed, you can use a method with ChangeInterceptor attribute to manage CUD operations and a QueryInterceptor attribute to manage Read operations. But if it’s a right logic, I think it should be … Continue reading

Posted in 7671, 8975, 9060 | 1 Comment

C#4: dynamic keyword

With C#4, there is a new keyword: dynamic. This keywork allow you to use an object without defining its type and to “try” to call any method. This allows you for example to call a javascript method, to do interop … Continue reading

Posted in 7671, 7672 | Leave a comment

Length too important, SP truncates instead of returning an error

Imagine that we have a stored procedure with a varchar(3) parameter. If we call it with “AZERTY” as parameter, the SP is executed as with “AZE” as parameter. I find it really bad! I think we should have a sql error and then if a .NET adapter … Continue reading

Posted in 7671, 9104 | Leave a comment

ADO.NET Data Services Hooking POC V3 .1

I just finished implementing the IUpdatable interface[:)] With ADO.NET Data Services, in the client part, you can use some LINQ queries which will be translated to an url. It’s really great to be able to use LINQ. However, this query … Continue reading

Posted in 7671, 7674, 8975, 9060 | 6 Comments

ADO.NET Data Services Hooking POC V3

The third version of my ADO.NET Data Services Hooking POC is released. The IUpdatable interface is partially implemented. I am waiting for an answer to my thread to implement ClearChanges and ResetResource methods. Note that it’s a POC, so my … Continue reading

Posted in 7671, 7674, 8975, 9060 | Leave a comment

Bug with IQueryable and yield syntax: System.BadImageFormatException "An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)"

I find a bug if you mix IQueryable and yield syntax. After Diego has changed a little bit my sample to reproduce it, this is the code he sent to the C# team: class Program {     static void Main(string[] args) … Continue reading

Posted in 7671, 7672, 7674, 7676, 7677, 7806 | 6 Comments

ADO.NET Data Services Hooking POC v2

I continue my POC development. In my previous version, I didn’t supported keys in url. I do now. So I can do something like this: http://localhost:50683/WebDataService.svc/Teams(guid’adbae845-989e-4aae-8273-0b4325556812′)/Employees I hope this POC will become more than a POC. ADO.NET Data Services has some limitations with EF: EF limitations  … Continue reading

Posted in 7671, 7674, 8975, 9060 | 5 Comments

ADO.NET Data Services Hooking POC

When you use ADO.NET Data Services, you will reduce the flow between the client and the server to get only the entities you really want. If you use EF with ADO.Net Data Services, you will also reduce the flow between … Continue reading

Posted in 7671, 7674, 8975, 9060 | 2 Comments

EF: how to do a recursive include?

I have a table Employees with three columns: EmployeeID(uniqueidentifier, PK), Name (nvarchar) and ManagerID(uniqueidentifier, FK to EmployeeID). I want to be able to get all the sub employees of an employee.  As confirmed me Jeff, this scenario isn’t supported by EF v1. … Continue reading

Posted in 7671, 7674, 7675 | Leave a comment