Thanks.

 

Following is the Query that i m using and it gives me the same error for inserting,updating or retrieving

 

And important thing is that i m facing problem for only one entity in whole model.

 

 

 

So is Dataset your sub-typed EntityManager, and ScheduledItems a method returning an EntityQuery<ScheduledItem>?  How many items should be returned by the query?

 

You say you also get this exception when doing inserts or updates for entities of this type?  I'm not sure I follow you.  Does the exception occur when making the SaveChanges() call?

 

What is different about the ScheduledItem entity than other entities in your model?  Is in inherited from another entity?  Does it have a multi-column key?  Does it contain any complex types?  What kinds of associations does it have with other entities?  Can you post the csdl for this entity and for any associations it's a part of?

 

Can you also post the full exception, including stack trace and inner exception(s), received when you run the query above?

 

Thanks.

Hi

 

Followig is the link to the csdl and other files that u suggetsed

 

uploads/20080529_003532_ModelFiles.rar

 

As i found yesterday is that it worked for the insert and update and retreival for single record

 

but when i retreive it for multiple records, it gives me the error

 

There are no associations with the entity scheduledItem and nothing new than other entites as it is auto generated by Idablade model

 

Following is the stacktrace of error

 

 

And InnerException is

 

 

I ran some simple tests with dummy data and couldn't reproduce the problem, so I think it might be data-related.  When you see the failure retrieving multiple records, how large is the ParametersXml field data?  Also, are you running with a BOS?

 

As I mentioned before, we did have several NullReferenceException problems with queries in Beta1 that should now be fixed in our soon-to-be-released Beta2 drop, so you might want to wait for Beta2 to see if this problem has been fixed.  If you don't want to wait (please don't ask for how long ), if it's not too much trouble you can send us both your database and a solution showing the failure.    (Send to mailto:support@ideablade.com - support@ideablade.com , attention Kim).

 

I can not give u the database and solution because its a secure thing and contract with the client(you can understand)

 

But yes i think it might be a problem with data and same thing is happened with another entity.(Same error)

In both the cases, common thing is XML data. both table includes xml data.

 

In my case, xml is not too large. Following is the sample xml that is stored in DB for each record and there are 13 records satisfy the condition.

 

"<?xml version="1.0" encoding="utf-16"?><ClaimPaymentParameterList xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance - http://www.w3.org/2001/XMLSchema-instance " xmlns:xsd=" - 7.22truetruefalsefalse0http://www.w3.org/2001/XMLSchema"><Amount>7.22</Amount><PayMember>true</PayMember><PayAch>true</PayAch><AllowPartialPayment>false</AllowPartialPayment><AllowCreditPayment>false</AllowCreditPayment><CheckFee>0</CheckFee></ClaimPaymentParameterList >"

 

Can u please suggest me what can be the solution?

Thanks in advance.

 

I've tried reproducing the problem with the ParametersXml data you posted, yet don't get an error.  I also tried changing the column data type from nvarchar(max) to xml to text - all without success in reproducing the problem.  What version of SQL Server are you using?

 

I'm stuck right now in diagnosing this.  Since the exception is occurring when retrieved data is merged into cache, you can try changing the QueryStrategy to see if that gets around the problem.  Try a QueryStrategy of DataSourceOnly to see what happens.

 

Thanks for your soluable reply.

 

It worked when i set QueryStrategy to DataSourceOnly

 

As for your knowledge, i m using SQL Server 2005 as a datasource.

 

Thanks again.