WCF Data Services [formerly known as ADO.NET Data Services] (Pre-Release) Forum

Code only and ADO.NET Data Services

Sat, 21 Nov 2009 19:50:58 Z

How to supply objectcontext generated by builder to ado.net data services?

Because of context is created by builder I cannot just put as generic parameter.

Or I'm missing something?

Complex query problem

Tue, 24 Nov 2009 19:43:05 Z

Hi guys,

I'm trying to make a query in Ado , but I can not.

string modulefunctionCode = string.Concat(Helpers.LoginInfo.CurrentModule, Helpers.Tables.CLIENTES, PermissionFunctions.View);

//List<int> deniedAccess = GetEmpresasWithDeniedAccess(modulefunctionCode);

// Justa an Exemplo
List<int> deniedAccess = new List<int>() {0, 1, 2, 3}

IQueryable<Cliente> result = DBEntities.Clientes.Expand("Empresa")
                .Where(r => (deniedAccess.Contains(r.Empresa.EmpresaId) == false || r.Empresa == null))
                .OrderBy(c => c.RazaoSocial);


// the problem is here, how can i do that?
.Where(r => (deniedAccess.Contains(r.Empresa.EmpresaId) == false || r.Empresa == null))

the error:

The expression ((value(System.Collections.Generic.List`1[System.Int32]).Contains([10007].Empresa.EmpresaId) = False) || ([10007].Empresa = null)) is not supported.

Luciano Correia

One-way Navigation properties not supported?

Thu, 26 Nov 2009 16:05:39 Z

I've created a one-way navigation property in my EF1 model and it works fine.

However, when I try to access this model using WCF Data Services 1.5CTP1 I get an error indicating that the number of properties on the Entity in my model doesn't match the number of properties on the Entity in my class (Presumably, the generated code from "Add Service Reference" ?)

So, my question is.....Does the 1.5CTP1 code generation support one-way navigation properties on EF1 models? (Or am I doing something wrong....)

Dave

ADO.NET Data Service returning "A Potentially Dangerous Request.Path value was detected from the client (&).

Thu, 26 Nov 2009 00:50:44 Z

I have an ADO.NET Data Service written in Visual Studio 2010 Beta 2 running IIS 6.1 on Windows 7 x64 (Phew!).

This service is returning the following message to the client when I query for http://localhost/Service/QueryService.svc/Departments('T%26E')

"A potentially dangerous Request.Path value was detected from the client (&)."

The reason that I am querying for T%26E is that I have an entity (Department) with a primary key (char) of "T&E". IIS seems to be intercepting this request and returning the error. All I have in my web application is this ADO.NET Data Service, with a web.config of:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
    <system.web>
        <compilation debug="true" targetFramework="4.0">
            <assemblies>
                <add assembly="System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
            </assemblies>
        </compilation>
        <authentication mode="Windows" />
    </system.web>

    <system.serviceModel>
        <behaviors>
            <serviceBehaviors>
                <behavior>
                    <serviceMetadata httpGetEnabled="true" />
                    <serviceDebug includeExceptionDetailInFaults="false" />
                </behavior>
            </serviceBehaviors>
        </behaviors>
        <serviceHostingEnvironment aspNetCompatibilityEnabled="true" />
    </system.serviceModel>
</configuration>

Has anyone had a similar problem? I have a feeling it is to do with IIS request validation, but I cannot see how to disable it for the service. There are lots of examples of how to turn of request validation for asp.net pages, but nothing for services. Am I missing something?

Exposing Abstract classes over Ria Service 2010 Preview

Mon, 23 Nov 2009 21:30:04 Z

I have created an empty Entity Data Model, create a new Entity named Dabases and made it abastract, next I have create a new entity named "SqlDatase" that inherits from "Databases" entity.

Next I created a new Domain Service to expose my entities, but the Databases is disable makes sense as it is abstract, but what about SqlDatabase? why cant I expose it?

Using VS2010, Ria Services Preview.

The way of C#

CTP 2 Windows Forms (Data Binding)

Mon, 16 Nov 2009 13:03:37 Z

I am planning to develop an application using ado data service V1.5 CTP2.

I tested version 1.0 of the ado data service and not have seen the use of DataBinding, and I get a lot of work having to control some property changes using the "SetLink" and "AddLink".

In CTP2 version I saw that there is a feature of "Data Binding" that can solve my problem.

But the description of the Action "Data Binding", he says it's for WPF and Silverlight. This is my question, because my application will be Windows Forms.

Can i use the ADO Data Service through a windows forms application?

Luciano Correia

What is the best caching strategy?

Tue, 24 Nov 2009 15:58:28 Z

I have a complex app using a dataservices backend. My app is split into multiple segments through the use of nested master pages, controllers, user controls and so on. All the segments tend to operate on the same object graph time after time, so I really need to keep a copy locally rather than request it again and again from each individual component......

If I store the object graph in session, that seems to work fine, but when I have multiple users looking at the same object graph they are each storing their own copy......Not ideal if 1 user adds a new leaf to the graph because the other session can't see it (Can't invalidate session B from session A....).

If I store the object graph in httpcontext.cache then it works to a point....However, retrieving an object graph from the cache and then using "context.AttachTo" on the root object doesn't seem to attach the rest of the graph to the context, so updates are all messed up.

I've looked at TryGetEntity and TryGetUri, but documentation and examples of their use is vague / nonexistent. However, they don't seem to prevent http requests anyway......?

Can anyone offer some assistance / point me at some best practice docs?

Dave

ToObservableEntityCollection Error

Sun, 05 Apr 2009 20:27:17 Z

My app is throwing an error on a clients test pc in the ToObservableEntityCollection() method. This works fine from other pc's I've tried and using a browser on the RESTful interface produces the correct set of data so I can only assume that the new client somehow has a problem. His machine is XP but I have tried other XP machines and they are fine.

This doesn't look good for my write once run anywhere the .Net framework is installed theory. Any ideas what could be the matter?

09:28:34""System.Data.Services.Client.DataServiceClientException: Error processing response stream. The ATOM entry had an in-stream error. ---> System.Xml.XmlException: Unexpected end of file has occurred. The following elements are not closed: feed, m:inline, link, entry, m:inline, link, entry, feed, m:inline, link, entry, feed. Line 242, position 35.
   at System.Xml.XmlTextReaderImpl.Throw(Exception e)
   at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
   at System.Xml.XmlTextReaderImpl.Throw(Int32 pos, String res, String arg)
   at System.Xml.XmlTextReaderImpl.ThrowUnclosedElements()
   at System.Xml.XmlTextReaderImpl.ParseElementContent()
   at System.Xml.XmlTextReaderImpl.Read()
   at System.Xml.XmlSubtreeReader.Read()
   at System.Xml.Linq.XContainer.ReadContentFrom(XmlReader r)
   at System.Xml.Linq.XContainer.ReadContentFrom(XmlReader r, LoadOptions o)
   at System.Xml.Linq.XElement.ReadElementFrom(XmlReader r, LoadOptions o)
   at System.Xml.Linq.XElement.Load(XmlReader reader, LoadOptions options)
   at System.Xml.Linq.XElement.Load(XmlReader reader)
   at System.Data.Services.Client.MaterializeAtom.PushBufferedReader(XElement& currentEntry)
   --- End of inner exception stack trace ---
   at System.Data.Services.Client.MaterializeAtom.PushBufferedReader(XElement& currentEntry)
   at System.Data.Services.Client.MaterializeAtom.ReadNextInternal(ClientType currentType, Type expectedType, AtomParseState atom, EntityStates& entityState, Object& currentValue, EpmReaderState readerState)
   at System.Data.Services.Client.MaterializeAtom.ReadNext(ClientType currentType, Type expectedType, AtomParseState atom, EntityStates& entityState, Object& currentValue, EpmReaderState readerState)
   at System.Data.Services.Client.MaterializeAtom.MoveNext()
   at System.Data.Services.Client.ObservableEntityCollection`1.ToObservableEntityCollection(DataServiceContext context, IEnumerable`1 items, String entitySet, EntityChanged entityChanged, EntityRefChanged refChanged, EntityCollectionChanged collectionChanged, ResolveEntitySetName entitySetNameResolver)
   at System.Data.Services.Client.QueryOperationResponse`1.ToObservableEntityCollection(String entitySet, EntityChanged entityChanged, EntityRefChanged refChanged, EntityCollectionChanged collectionChanged, ResolveEntitySetName entitySetNameResolver)
   at System.Data.Services.Client.QueryOperationResponse`1.ToObservableEntityCollection()
   at Nova.Content.Controls.Generic.MVCCommands.SearchCommand`2.<>c__DisplayClass3.<Execute>b__0(IAsyncResult ar)"

Thanks

Best practices for exposing DTOs via Service Operations on ADO.NET Data Services version1.5

Wed, 11 Nov 2009 01:42:18 Z

I posted this in the data platform forums, but I didn't get too clear an answer. I would like to know what the best practices are for utilizing and exposing DTOs in an ADO.NET Data Service version 1.5 in VS2010 beta 2. As much as I love all the possibilities that can be achieved with projections, there are scenarios in which I'll need to do a custom query that returns a DTO which doesn't conform to an entity in my domain model. I've tried to find more information on this subject, but so far I've only read that custom service operations can only return entities from the Entity Data Model that is being exposed by the service.

METHOD 1: Nonetheless, I tried the most straightforward approach first; I created a regular CLR class and use it as a DTO and use RegisterKnownType in InitializeService:

config.RegisterKnownType(typeof(EntityWithCount));

I use this code for the service operation:

[WebGet]
public IEnumerable GetEntitiesWithCount(int parentId) {
	return CurrentDataSource.Entity
		.Where(x => x.Parent.Id == parentId)
		.Select(x => new EntityWithCount { Id = x.Id, Name = x.Name, ChildCount = x.Children.Count });
}

But I get the error: 'Unable to load metadata for return type 'System.Collections.Generic.IEnumerable`1[EntityWithCount]' of method 'System.Collections.Generic.IEnumerable`1[EntityWithCount] GetEntityWithCount(Int32)'

METHOD 2: Is my only option to create an Entity in the model that isn't mapped to a table in the database? Because when I try to create an unmapped entity in the entity data model, i get this error using it in the ADO.NET Data Service:

The server encountered an error processing the request. The exception message is 'Service operation 'EntityWithCount' produces instances of type 'EntityWithCount', but there are no visible entity sets for that type. The service operation should be hidden or a resource set for type 'EntityWithCount' should be made visible.'.

METHOD 3: So finally, i try to create a complex type in the EntityDataModel, and use it as my DTO. This has been the most favorable in the sense that the service wasn't faulting, and I could return my DTO safely from the service operation *assuming* i directly instantiated the objects. However, when actually trying to create a projection query via the ObjectContext:

return CurrentDataSource.Entity
	.Where(x => x.Parent.Id == parentId)
	.Select(x => new EntityWithCount{ Id = x.Id, Name = x.Name, ChildCount = x.Children.Count }).ToList();

I get the error:

The entity or complex type 'EntityWithCount' cannot be constructed in a LINQ to Entities query.

Just by changing the query to an anonymous type:

return CurrentDataSource.Entity
	.Where(x => x.Parent.Id == parentId)
	.Select(x => new { Id = x.Id, Name = x.Name, ChildCount = x.Children.Count }).ToList();

The query will be successful, but of course I can't return the anonymous type from the service, because i get the same error that i received in method 1! All I'm trying to do is simply handle more complex situations with custom service operations, and expose them on the data service.

I'm hoping someone can show me the best method to accomplish this, assuming it's even possible at all! Thanks.

Is it safe to use HttpContext during a request?

Thu, 19 Nov 2009 18:37:31 Z

Is it safe to use the HttpContext.Items to store/retrieve data that we need access to during the processing of a request to WCF Data Services? Will that data be available through the life of the request?

Filtering on a many-to-many relation impossible?

Thu, 12 Nov 2009 09:28:15 Z

Hi,
I'm building a line-of-business application framework using silverlight and astoria and I've ran into a problem concerning filtering data that is stored in a many-to-many relation. To explain the issue I've created a model that contains a Person entity, each person can have one or more features like brown eyes or gray hair and so on.
The model looks like this:

Person - PersonFeatureLink - Feature

I now want to query each person that has the feature 'brown eyes', I came op with the following:

public void LoadAnyPersonWithBrownEyesAsync()
{
    DemoModel.DemoEntities context = new DemoModel.DemoEntities(new Uri("WebDataService1_5CTP1.svc", UriKind.Relative));

    var query = from p in context.Person
                    .Expand("PersonFeatureLink/Feature")
                where p.PersonFeatureLink.Any(q => q.Feature.Description == "BrownEyes")
                select p;

    DataServiceQuery<DemoModel.Person> userQuery = (DataServiceQuery<DemoModel.Person>)query;
    userQuery.BeginExecute(new AsyncCallback(OnLoadCollectionComplete), userQuery);
}

When executing this code, Astoria reports that the 'Any' method is not supported.
I have tried countless alternative ways to fomulate this query but none of them worked.

I would really like to know if there is a way to get this query to work. Or maybe someone can provide a workaround.

Thanks!
Johan

relation problem in ado.net

Sat, 14 Nov 2009 13:41:27 Z

i have problem ,if their is no record in databse for relation

please guid me ,so in database i have to put one record

some code

Dim colMaster11 As DataColumn

Dim colDetail1 As DataColumn

colMaster11 = Busgerneral.gerneral.Tables(tableFoood).Columns(

"Fid")

colDetail1 = Busgerneral.gerneral.Tables(tableIngredient).Columns(

"Fid")

relFoodspIngre =

New DataRelation("RelFoodIng", colMaster11, colDetail1, False)

Busgerneral.gerneral.Relations.Add(relFoodspIngre)

viewManager =

New DataViewManager(Busgerneral.gerneral)

dtgIng.DataSource =

Nothing

dtgIng.DataSource = viewManager

dtgIng.DataMember =

"foodsp.RelFoodIng" ' error come out

An error occurred while processing this request. ---> System.InvalidOperationException: The boundary delimiter '--batchresponse

Tue, 10 Nov 2009 06:14:12 Z

When we do any bacth update the following exception occures eventhough the data is updated in database. Any inputs on this ?
System.Data.Services.Client.DataServiceRequestException: An error occurred while processing this request. ---> System.InvalidOperationException: The boundary delimiter '--batchresponse_bfe43278-f011-493f-a32a-7f4bf2d4c5f1Content-Type: multipart/mixed; boundary=changesetresponse_50871887-18b3-41bd-9194-21fcb9322503--changesetresponse_50871887-18b3-41bd-9194-21fcb9322503Content-Type: application/httpContent-Transfer-Encoding: binaryHTTP/1.1 201 CreatedContent-ID: 1Cache-Control: no-cacheDataServiceVersion: 1.0;Content-Type: application/atom+xml;charset=utf-8Location: https://rpmbusiness.sharepoint.uop.com/RPM.Data.DataService/RPMDataService.svc/Calculation(guid'e00dd159-4c29-45d0-8114-f90671a90d7c')<?xml version="1.0" encoding="utf-8" standalone="yes"?><entry xml:base="https://rpmbusiness.sharepoint.uop.com/RPM.Data.DataService/RPMDataService.svc/" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns="http://www.w3.org/2005/Atom"><id>https://rpmbusiness.sharepoint.uop.com/RPM.Data.DataService/RPMDataService.svc/Calculation(guid'e00dd159-4c29-45d0-8114-f90671a90d7c')</id><title type="te...' is not valid. Please specify a valid boundary delimiter or make sure that the content length specified is correct.

   at System.Data.Services.Client.BatchStream.MoveNext()

   at System.Data.Services.Client.DataServiceContext.SaveResult.<HandleBatchResponse>d__20.MoveNext()

   at System.Data.Services.Client.DataServiceContext.SaveResult.HandleBatchResponse()

   --- End of inner exception stack trace ---

Generated Silverlight 3 Client side entities missing INotifyPropertyChanged interface for Data Services CTP2

Tue, 10 Nov 2009 19:02:50 Z

When creating a WebService reference to a data services v1.5 CTP2 service the generation of the service reference uses the System.Data.Services.Client dll instead of the Microsoft.Data.Services.Client dll provided by CTP2. The server side project for data services references the Microsoft.Data.Services.* dlls and the markup for the .svc file also references the Microsoft.Data.Services.Client dll. The proxy code genereted in the Silverlight client does not have the INotifiedPropertyChanged interface. When trying to load a DataServiceCollection<T> the system generates an error stating the the INotifyPropertyChanged interface is not defined. A reference to System.Data.Services.Client is automatically added by the add service reference function. Changing this to Microsoft.Data.Services.Client will allow the program to compile but not load the DataServiceCollection. VS2008 SP1 on Vista or Win7 gets same result.

Request Pipeline

Mon, 09 Nov 2009 16:19:39 Z

Has anyone seen any info on the Request Pipeline additions in CTP2? I've seen plenty of posts from the Ado.NET Data Services team and others declaring that there has been improvments made, but I've not seen any detail as yet! Can anyone point to any info on what's possible now as regards working with the request pipeline?

Cheers,
Greg

Initiating a projection from the server side

Mon, 09 Nov 2009 14:49:31 Z

Hi, I've got the new projections feature in CTP2 working in that I can create a URL asking for specific columns and those columns are returned. That's great stuff.

However, what I want to do now is initiate a projection from the server side. I have a service operation which I'd like to return an IQueryable<MyObject> from. However, I want to only return certain columns from within MyObject. I thought something like this would work:

        [WebGet]

        public IQueryable<User> DoQuery(string query)

        {

            return (from u in CurrentDataSource.Users select new { Id = u.Id, LastName = u.LastName }).ToList().Select(uu => new User { Id = uu.Id, LastName = uu.LastName }).AsQueryable();

        }

However, although this does return only the field values I want, the rest of the fields are still put back to the client in each entity (just with null values). Is there any way to shape the return feed so that only those columns I want are returned? I don't want to rely on the client having to specify a $select option on the call to my service operation - I want to force it.

Cheers,
Greg

Howto use IDataServiceStreamProvider

Mon, 09 Nov 2009 12:50:19 Z

Is there any information about how to implement the interface IDataServiceStreamProvider ?
I can't find any info about the streaming of blobs using this interface.

Any help would be great,

Klaas

two entity model and two data service inside the same dll?

Mon, 31 Aug 2009 14:43:23 Z

I am using data service against entiry framework, when i create two entity model in the same class library and create two data service inside this dll, it seems that this method will cause problem? So my questions is : is it possible to put two entity model and two data service inside the same dll and how ? I hope that one expert can help me solve this problem.

Thanks.

AddLink, SetLink... between entities in v1.5

Thu, 29 Oct 2009 17:32:07 Z

Dear development team,

Guys, do you have any plans for the v1.5 to remove necessity for manual operation with links between related entities (using AddLink, SetLink etc.)?

Why isn't possible there to simply track relations using subscription on DataServiceCollection's events and/or by a single recursive pass through references inside objects tree during SaveChanges process.

Thank you for you job!

Why doesn't tracked entity send update request

Tue, 27 Oct 2009 18:35:41 Z

Here there,

I am wondering if anyone can explain this to me. I have an entity that is tracked by the context using latest 1.5 CTP 2, but when I modify a value of the property and then call BeginSaveChanges, no updates are sent to server. However, if I do an UpdateObject first - it works just fine.

It doesn't make sense to me because I really thought that the context would know when a tracked entity is modified and will therefore save it appropriately.

I can give code, but I figure plain language might be easier for now. :-)

Thanks!

specifying a mime type for a specific property's $value operator

Thu, 29 Oct 2009 00:16:59 Z

VS2010 B2, ADO.NET Data Service backed by an Entity Framework model of an SQL Server 2008 AdventureWorks database.

Calling http://localhost/AdventureWorks.svc/ProductPhotoes(69)/ThumbNailPhoto/$value returns an image of bicycle, as expected. Apparently, there is some special magic somewhere that indicates the mime type or IE just knows it's an image. I think the later.

However, I'm more intrested in returning an mp3 from the database and specifying a mime-type. So I've updated a single record in the AW database and replaced the ThumbNailPhoto varbinary(max) contents with a Coldplay mp3. When I run the same query as above, I'm prompted to save the file.

My next step was to create a Service Operation called GetProductAudio that returns the binary data. I used the [System.Data.Services.MimeType("GetProductAudio", "audio/mpeg")] attribute on the DS class and it works exactly as expected. I query the service and Viva La Vida starts playing in Windows Media Player.

The /ThumbNailPhoto/$value and GetProductAudio are retreiving and returning the same data, the only difference is that GetProductAudio specifies a mime type.

1. How do I specify the mime type for ThumbNailPhoto so when I use the $value operator the binary data comes down with a mime type in the response header? From other posts I've read, it sounds like I should be able to specify a MimeType="audio/mpeg" attribute in the EF CSDL for the ThumbNailPhoto property, but I've had no luck in doing this. http://social.msdn.microsoft.com/Forums/en/adodotnetdataservices/thread/05b3bec2-ebed-4fc0-bb5b-e2d3be5fe3b7 and http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataservices/thread/818a7491-45ef-4bce-9c4a-bbcfd2151785/ and http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataservices/thread/f0a559be-1681-43ce-8c91-5eed289df24f

The xmlns being used in the examples above don't seem to exist in VS2010 B2. It seems like it would be easier to modify the CSDL with an attribute than create a Service Operation everytime you want to specify a mime type for a property's $value operator.

2. Of lesser importance. Why is the System.Data.Services.MimeTypeAttribute marked as AllowMultiple = false? It seems as though I would need to decorate the Data Service class with a MimeType attribute for each ServiceOperation that needed a specific mime type specified. So if I had 3 Service Operations that I wanted to control the Mime Type, how would I do that if they were all different types?

Thanks,

Greg

ServiceOperations and Boolean Parameters in a VB client

Wed, 14 Oct 2009 11:40:37 Z

Guys,
I'm using 1.5CTP1 and I've just spent a couple of hours trying to work out why my client-side code always gave me "Bad Request" error when I called my Service Operation, but I could call it just fine using the URL directly.

It turns out that a boolean in vb.net equates to "True" or "False" in the query string, but a boolean parameter to a service operation can only be accepted as "true" or "false".

No big deal, I've just put an IIF(param,"true","false") around it but I thought you would want to know so you can fix it in the next version :)

Dave

InotifyPropertychanged and implemnting custom logic

Mon, 12 Oct 2009 17:54:06 Z

I have a situation where I would like to do some calculation when a property changes(similar to qantity of a product changing and Total has to be updated).
what is the best way to do this. where would the code be executed?

Thanks

http://leeontech.wordpress.com/

Getting Row Count in ADO.Net Data Services(w/ Silverlight). Please help!

Mon, 12 Oct 2009 18:18:43 Z

Hi,

I read through Peter Qian's article about returning the total count of entities here:
http://blogs.msdn.com/peter_qian/archive/2009/03/18/getting-row-count-in-ado-net-data-services.aspx

And I can't seem to figure out how to get the total count. The following example doesn't work in Silverlight because the 2nd line is a Synchronous call:

var q = (from c in ctx.CreateQuery<Customers>(“/Customers”).IncludeTotalCount().Take(5) select c) as DataServiceQuery<Customers>;
var results = q.Execute() as QueryOperationResponse<Customers>;
long countValue = results.TotalCount;

Is there a way to get to the QueryOperationResponse from a Silverlight client? Or at this point, do I need to start parsing the atom myself?

Thanks. -jogi

System.Data.Services.Client referenced incorrectly for CTP2

Sat, 19 Sep 2009 07:53:50 Z

I have been following this post to get started with the ADO.NET Data Services 1.5 CTP2 and Silverlight 3:
http://blogs.msdn.com/astoriateam/archive/2009/09/01/introduction-to-data-binding-in-ctp2.aspx

It very specifically says to make sure Microsoft.Data.Services.Client is included after adding the Web Service Reference to the Silverlight app. Every time I add the web reference, I continue to get System.Data.Services.Client instead. I have followed all the steps, but continue to get the wrong one.

Subsequently, I am getting the following (possibly) related error when trying to use the data service:

"An attempt to track an entity or complex type failed because the entity or complex type 'MyApp.MyDataSvc.Member' does not implement the INotifyPropertyChanged interface." -> BTW: "Member" is the name of the table.

Has anyone else run into this same issue or have any suggestions?

Thanks,
Tom

Side by side installation of CTP 2

Tue, 06 Oct 2009 19:39:45 Z

Can the CTP 2 be installed side by side with the version that shipped with .net 3.5 sp1?

thx

http://leeontech.wordpress.com/

Problem with CTP2 when using DLinq, QueryInterceptor and $expand

Thu, 08 Oct 2009 15:23:36 Z

Hello,

I have been running Linq to SQL context with ADO.NET Data Services in various projects for a while now. In most cases I have been using it along with query interceptors and $expand instruction and had no problems. Today I installed CTP2 to give it a try and encountered nasty problem as follows.

While trying to access URL: http://localhost:64944/DataService.svc/Classes?$expand=Members

Error message: Could not translate expression 'p.Members.Where(o => (o.GuildId = 1))' into SQL and could not treat it as a local expression.

Stack trace:

at System.Data.Linq.SqlClient.ObjectReaderCompiler.Generator.Generate(SqlNode node, LocalBuilder locInstance)
at System.Data.Linq.SqlClient.ObjectReaderCompiler.Generator.GenerateExpressionForType(SqlExpression expr, Type type, LocalBuilder locInstance)
at System.Data.Linq.SqlClient.ObjectReaderCompiler.Generator.GenerateSearchedCase(SqlSearchedCase ssc)
at System.Data.Linq.SqlClient.ObjectReaderCompiler.Generator.Generate(SqlNode node, LocalBuilder locInstance)
at System.Data.Linq.SqlClient.ObjectReaderCompiler.Generator.GenerateExpressionForType(SqlExpression expr, Type type, LocalBuilder locInstance)
at System.Data.Linq.SqlClient.ObjectReaderCompiler.Generator.GenerateAssignValue(MetaDataMember mm, LocalBuilder locInstance, SqlExpression expr, LocalBuilder locStoreInMember)
at System.Data.Linq.SqlClient.ObjectReaderCompiler.Generator.GenerateMemberAssignment(MetaDataMember mm, LocalBuilder locInstance, SqlExpression expr, LocalBuilder locStoreInMember)
at System.Data.Linq.SqlClient.ObjectReaderCompiler.Generator.GenerateNew(SqlNew sn)
at System.Data.Linq.SqlClient.ObjectReaderCompiler.Generator.Generate(SqlNode node, LocalBuilder locInstance)
at System.Data.Linq.SqlClient.ObjectReaderCompiler.Generator.GenerateExpressionForType(SqlExpression expr, Type type, LocalBuilder locInstance)
at System.Data.Linq.SqlClient.ObjectReaderCompiler.Generator.GenerateBody(ILGenerator generator, SqlExpression expression)
at System.Data.Linq.SqlClient.ObjectReaderCompiler.CompileDynamicMethod(Generator gen, SqlExpression expression, Type elementType)
at System.Data.Linq.SqlClient.ObjectReaderCompiler.Compile(SqlExpression expression, Type elementType)
at System.Data.Linq.SqlClient.SqlProvider.GetReaderFactory(SqlNode node, Type elemType)
at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
at System.Data.Linq.DataQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
at System.Data.Services.Providers.BasicExpandProvider.ExpandedQueryable`1.GetEnumerator()
at System.Data.Services.Providers.BasicExpandProvider.ExpandedQueryable`1.System.Collections.IEnumerable.GetEnumerator()
at System.Data.Services.WebUtil.GetRequestEnumerator(IEnumerable enumerable)
at System.Data.Services.DataService`1.SerializeResponseBody(RequestDescription description, IDataService dataService)
at System.Data.Services.DataService`1.HandleNonBatchRequest(RequestDescription description)
at System.Data.Services.DataService`1.HandleRequest()

Looking at the stack trace it seems the query tree composed by Data Services is invalid for DLinq to process, as it composed my query interceptor, but in a way that made it unparsable.

My interceptor was:

[QueryInterceptor("Members")]
public Expression<Func<Member, bool>> LimitGuild()
{
return o => o.GuildId == 1;
}

btw I made also a test and recreated equivalent context for Entity Framework and all was fine, so it seems the issue is limited only to L2S.

Maciej

Is it possible to create RESTful web services using ASP.NET 2.0?

Mon, 03 Aug 2009 06:00:38 Z

Hi All,

Is it possible to create RESTful web services using ASP.NET 2.0?

If Yes then please let me know how it can be done?

Your earliest response on this matter would be highly appreciable.

Thanks in advance.

Cannot Find Some SqlServer.Management objects

Sat, 26 Sep 2009 00:58:57 Z

I have some C# code in .Net 3.5 to find the disk drive of where our product's SQL Server database files are stored (the code also does a few other database management-related tasks). I've been using something like this:

using Microsoft.SqlServer.Management.Common;
using Microsoft.SqlServer.Management.Smo;
using System.Data.SqlClient;
.
.
.
// Connect to SQL Server to gain access to the database.
SqlConnection sqlConnection = new SqlConnection("MyConnectionString");
ServerConnection serverConnection = new ServerConnection(sqlConnection);
Server server = new Server(serverConnection);

foreach (FileGroup fg in server.Databases["MyDatabase"].FileGroups)
    foreach (DataFile f in fg.Files)
    {
        // Get drive of where data and log files are stored
    }

// I also access other objects, such as...
double dataSpaceUsed = server.Databases["CEMLink"].DataSpaceUsage;
double indexSpaceUsed = server.Databases["CEMLink"].IndexSpaceUsage;

In 4.0, however, this code will not compile because it cannot find the Microsoft.SqlServer.Management.Common.Server object. If I set the project's Target Framework to 3.5 this code works great, but as soon as I change the Target Framework to 4.0 I loose the Server object. I have references to Microsoft.SqlServer.ConnectionInfo, Microsoft.SqlServer.Management.Sdk.Sfc, Microsoft.SqlServer.Smo and Microsoft.SqlServer.SqlEnum.

Anyone know where I can find the equivalent of this object in .Net 4.0? Or have an idea of how I can find out the disk drive of where our database files are stored? Thanks!

Side-Note: The ADO.NET Data Services is probably not the best place to post this issue (my apologies), but I wasn't sure where was best. So thanks for everyone's consideration.

Astoria CTP2, entities not showing up in webdataservice.

Wed, 09 Sep 2009 14:18:29 Z

Hi,
I've just upgraded from CTP1 to CTP2 and I'm trying to update my project to use CTP2. I have created a new webdataservice using the CTP2 template and made it point to the same entity framework datamodel I was already using with CTP1.
When I set the webdataservice as the start page and run the application, all I see is:

<? xml version="1.0" encoding="utf-8" standalone="yes" ?>
- < service xml:base =" http://localhost:60425/WebDataService2.svc/ " xmlns:atom =" http://www.w3.org/2005/Atom " xmlns:app =" http://www.w3.org/2007/app " xmlns =" http://www.w3.org/2007/app " >
- < workspace >
< atom:title > Default </ atom:title >
</ workspace >
</ service >

I have created an empty project and tried it again but the results were the same..
Any idea?

Best regards,
Johan

I can't pass parameter to [WebInvoke] method

Fri, 18 Sep 2009 14:23:14 Z

Hi,

I need to call ADO.NET Data Services operation method that is marked with [WebInvoke] attribute.
But I can't pass parameter to this method, it's always null on the server side.
Parameter must be passed in the body of "POST" request, not in the url (it can be too large for query stirng, 10-50 kb for example).

I tried to find some example on this forum and "ADO.NET Data Services " forum, but I found only advices to use query string (www.example.com/DataService.svc/method?param=value) or unanswered questions.

Could somebody give some example?

My code (not real, only for demonstration):

Server side

[WebInvoke]
public void ValidateData(String data)
{
// unfortunately, data is always null
}

Client code:

String param = "data='some data'";
HttpWebRequest req = (HttpWebRequest)WebRequest.Create("http://localhost:4216/DataService.svc/ValidateData");
req.Method = "POST";
req.ContentLength = param.Length;
req.ContentType = "application/xml";
Stream sw = req.GetRequestStream();
Byte[] bytes = Encoding.ASCII.GetBytes(param);
sw.Write(bytes, 0, bytes.Length);
WebResponse resp = req.GetResponse();

Thanks,
Sergey

Are the 1.5 features expected to ship as part of .NET 4.0?

Tue, 01 Sep 2009 15:35:32 Z

The blog post alludes to 1.5 shipping with fx 4.0 but I wanted to double check - is that correct? If that's true will we get a refresh with .NET 4 beta 2 at PDC?

v1.5 CTP (Not CTP2) and Count....Where or Where.....Count

Thu, 24 Sep 2009 13:45:07 Z

I'm developing with the original CTP1.5 release and I came across this today. Is it fixed in CTP2 ?

I want a query:

http://mylocalservice/DataService/Service.svc/MyTable()/$count?$filter=IsPublished eq false

So I started with....

        Dim c = ctx.MyTable.Count( _
                Function(a As MyRec) (a.IsPublished = False))

but I got a "Not Supported" error.

However.....

        Dim c = ctx.MyTable.Where(Function(a As MyRec) (a.IsPublished = False)).Count()

works just fine.

"Select Count...Where" seemed more logical to me than "Select Where....Count" - and Select Count Where is what appears in the url too.

Transactional Replication WebService

Mon, 28 Sep 2009 18:17:33 Z

Hey Sir,
I want to perform Transactional replication using webservice. I have no idea which Api will used to achieve this, how can i ping the Publishers, how can i make subscriber by code, actually i performed all manually, but little confuse to perform with webservice, please guide me how can i achieve this.

How to handle complex (no CRUD) SP with RIA Services?

Wed, 23 Sep 2009 10:33:51 Z

I would like to use .NET RIA Services to access my database from Silverlight but I have one problem – all post I have read are abut CRUD access to tables – using direct access to tables or SP and with support of Entity Framework or LinqToSql. Everything is nice but 90% of my solutions use SP to get a view of data with some joins (not one table like in most of the samples). When I try to use this kind of SP with LinqToSql this SP was not visible on client (Silverlight side) and no business object is generated – I only see tables mapped from database. I’m not good in Entity Framework but I can’t figure out how to use sp that return data from many tables – I have couple of problems (for instance all primary keys from source tables must be in entity, there is some concurrency with Entities when I try to use same source table for couple Entities and so on). My needs are very simple – I would like to generate SP proxy for SP that returns data from many tables and auto generate business object returned from this SP (precisely list of this objects) and as far as RIA Services are concern I would like to handle it form Silverlight with RIA Services – it is possible?

Validation

Fri, 11 Sep 2009 13:28:00 Z

What is the best way for validation? Where to put it? On the serverside/clientside?
How and where to write them?

Say I have a field UnitPrice and this price cannot be less then 0...

Compression of bloated atom+xml

Tue, 25 Aug 2009 04:20:20 Z

Is there any way to compress the DataServiceContext traffic to or from a server?

There seems to be half a solution, in applicationHost.config setting the:

<httpCompression directory="%SystemDrive%\inetpub\temp\IIS Temporary Compressed Files">
  <dynamicTypes>
     ...
     <add mimeType="*/*" enabled="true" />
  </dynamicTypes>
</httpCompression>

And on the Context:

wr.Headers.Add("Accept-Encoding: gzip");

Which is nice because it automatically compresses it when returned from the server.

But then there's no way of getting the Client to decompress the result; it just falls flat on it's face. Is there a way to:

1. get the client to decompress the message;

2. hook into the message before the client processes it;

Thanks

Geoff

The method 'Join' is not supported.

Thu, 03 Sep 2009 17:42:42 Z

When i use the join inside the dataservice client application , it will give the following error:

The method 'Join' is not supported.

How should I solve this problem?

Thanks.

Azure Table Storage

Tue, 01 Sep 2009 16:29:41 Z

Are the necessary extensibility point there to have ADO.NET DS expose data from Azure's Table Storage? I saw that some provider flexibility is available. What's a good place to start?

How to make the entity property show up in the serverice reference?

Fri, 28 Aug 2009 19:48:26 Z

I have the following property ProductID inside the file of entity framework designer.cs , and I use data service against this entity framework, but when I add service reference in another class library project inside the solution, the productId property did not show up in the reference.cs file, so I can not use it, I hope that one expert can help me how to populate this field to reference.cs so I can use it in that class library.

[global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute()]
        [global::System.Runtime.Serialization.DataMemberAttribute()]
        public string ProductID
        {
            get
            {
                return this._ProductID;
            }
            set
            {
                this.OnProductIDChanging(value);
                this.ReportPropertyChanging("ProductID");
                this._ProductID = global::System.Data.Objects.DataClasses.StructuralObject.SetValidValue(value, true);
                this.ReportPropertyChanged("ProductID");
                this.OnProductIDChanged();
            }
        }
        private string _ProductID;
        partial void OnProductIDChanging(string value);
        partial void OnProductIDChanged();

Thanks.