I am having a hard time with ADO.NET Data Services (formerly code-named Astoria) as it gives me a bogus exception when I try to insert a new entity from
the silverlight client and trying
in a clean project (the same code) doesn't.
In both cases, however, data is correctly inserted into
the database. Using Fiddler (an HTTP debugger I could see that there is no problem
in the HTTP communication as I will show later
in this question.
The code :
var ctx = new MyProject123Entities(new Uri("http://andreiri/MyProject.Data/Data.svc"));
var i = new Zone()
{
Data = DateTime.Now,
IdElement = 1
};
ctx.AddToZone(i);
i.StareZone = new StareZone() { IdStareZone = 1 };
ctx.AttachTo("StareZone", i.StareZone);
ctx.SetLink(i, "StareZone", i.StareZone);
i.TipZone = new TipZone() { IdTipZone = 1 };
ctx.AttachTo("TipZone", i.TipZone);
ctx.SetLink(i, "TipZone", i.TipZone);
i.User = new User() { IdUser = 2 };
ctx.AttachTo("User", i.User);
ctx.SetLink(i, "User", i.User);
ctx.BeginSaveChanges(r =] ctx.EndSaveChanges(r), null);
when run
the last line (ctx.EndSaveChanges(r)) will throw
the following exception :
System.Data.Services.Client.DataServiceRequestException was unhandled by user code
Message="An error occurred while processing this request."
StackTrace:
at System.Data.Services.Client.DataServiceContext.SaveAsyncResult.HandleBatchResponse()
at System.Data.Services.Client.DataServiceContext.SaveAsyncResult.EndRequest()
at System.Data.Services.Client.DataServiceContext.EndSaveChanges(IAsyncResult asyncResult)
at MyProject.MainPage.[]c__DisplayClassd6.[]c__DisplayClassd8.[dashboard_PostZoneCurent]b__d5(IAsyncResult r)
at System.Data.Services.Client.BaseAsyncResult.HandleCompleted()
at System.Data.Services.Client.DataServiceContext.SaveAsyncResult.HandleCompleted(PerRequest pereq)
at System.Data.Services.Client.DataServiceContext.SaveAsyncResult.AsyncEndRead(IAsyncResult asyncResult)
at System.IO.Stream.BeginRead(Byte[] buffer, Int32 offset, Int32 count, AsyncCallback callback, Object state)
at System.Data.Services.Client.DataServiceContext.SaveAsyncResult.AsyncEndGetResponse(IAsyncResult asyncResult)
InnerException: System.InvalidOperationException
Message="
The context is already tracking a different entity with
the same resource Uri."
StackTrace:
at System.Data.Services.Client.DataServiceContext.AttachTo(Uri identity, Uri editLink, String etag, Object entity, Boolean fail)
at System.Data.Services.Client.MaterializeAtom.MoveNext()
at System.Data.Services.Client.DataServiceContext.HandleResponsePost(ResourceBox entry, MaterializeAtom materializer, Uri editLink, String etag)
at System.Data.Services.Client.DataServiceContext.SaveAsyncResult.[HandleBatchResponse]d__1d.MoveNext()
InnerException:
(there is no further information regarding
the exception although
the ADo.NET Data Service is configured to return detailed informations)
However
the row is inserted correctly and completely
in the database. Using fiddler I can see that
the request :
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<entry 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">
<category scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" term="MyProject123Model.
Zone" />
<title />
<updated>2009-09-11T13:36:46.917157Z</updated>
<author>
<name />
</author>
<id />
<link href="http://andreiri/MyProject.Data/Data.svc/StareZone(1)" rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/StareZone"
type="application/atom+xml;type=entry" />
<link href="http://andreiri/MyProject.Data/Data.svc/TipZone(4)" rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/TipZone"
type="application/atom+xml;type=entry" />
<link href="http://andreiri/MyProject.Data/Data.svc/User(4)" rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User"
type="application/atom+xml;type=entry" />
<content type="application/xml">
<m:properties>
<d:Data m:type="Edm.DateTime">2009-09-11T16:36:40.588951+03:00</d:Data>
<d:Detalii>aslkdfjasldkfj</d:Detalii>
<d:IdElement m:type="Edm.Int32">1</d:IdElement>
<d:IdZone m:type="Edm.Int32">0</d:IdZone>
<d:X_Post m:type="Edm.Decimal">587647.4705</d:X_Post>
<d:X_Repost m:type="Edm.Decimal" m:null="true" />
<d:Y_Post m:type="Edm.Decimal">325783.077599999</d:Y_Post>
<d:Y_Repost m:type="Edm.Decimal" m:null="true" />
</m:properties>
</content>
</entry>
is well accepted and a successful response is returned :
HTTP/1.1 201 Created
Date: Fri, 11 Sep 2009 13:36:47 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
X-AspNet-Version: 2.0.50727
DataServiceVersion: 1.0;
Location: http://andreiri/MyProject.Data/Data.svc/Zone(75)
Cache-Control: no-cache
Content-Type: application/atom+xml;charset=utf-8
Content-Length: 2213
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<entry xml:base="http://andreiri/MyProject.Data/Data.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>http://andreiri/MyProject.Data/Data.svc/Zone(75)</id>
<title type="text"></title>
<updated>2009-09-11T13:36:47Z</updated>
<author>
<name />
</author>
<link rel="edit" title="
Zone" href="Zone(75)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CenterZone" type="application/atom+xml;type=feed" title="CenterZone" href="Zone(75)/CenterZone" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ZoneMobil" type="application/atom+xml;type=feed" title="ZoneMobil" href="Zone(75)/ZoneMobil" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/StareZone" type="application/atom+xml;type=entry" title="StareZone" href="Zone(75)/StareZone" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/TipZone" type="application/atom+xml;type=entry" title="TipZone" href="Zone(75)/TipZone" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="Zone(75)/User" />
<category term="MyProject123Model.
Zone" scheme="http://schemas.microsoft.com ado/2007/08/dataservices/scheme" />
<content type="application/xml">
<m:properties>
<d:IdZone m:type="Edm.Int32">75</d:IdZone>
<d:X_Post m:type="Edm.Decimal">587647.4705</d:X_Post>
<d:Y_Post m:type="Edm.Decimal">325783.077599999</d:Y_Post>
<d:X_Repost m:type="Edm.Decimal" m:null="true" />
<d:Y_Repost m:type="Edm.Decimal" m:null="true" />
<d:Data m:type="Edm.DateTime">2009-09-11T16:36:40.588951+03:00</d:Data>
<d:Detalii>aslkdfjasldkfj</d:Detalii>
<d:IdElement m:type="Edm.Int32">1</d:IdElement>
</m:properties>
</content>
</entry>
Why do I get an exception? And, using this
in a clean project does not throw
the exception..
