WCF Data Services (formerly known as ADO.NET Data Services) Forum

Microsoft Open Data Visualizer extensibility

Sun, 29 Nov 2009 00:10:26 Z

Is there any way to extend the visualizer shapes to provide additional information?

Thanks a lot,
~Mariano

No return type for Store Procedure in LINQ to SQL

Fri, 27 Nov 2009 05:55:06 Z

Actually, I did not find the right place to post LINQ to SQL related topic, feel free to move this if it was wrong.

When I map the store procedure to data function using LINQ to SQL, some times the tool can generate the Return Type(Auto-generated Type), but sometimes the Return Type is none even the same store procedure.
I do not know the reasons.
I'd appreciated if some one give me some advices.

rapid set of calls through ADO.NET Data Services client seems to result in 403.9 too many users connected response or timeout

Fri, 20 Nov 2009 17:55:52 Z

This usually only manifests itself when I am running my unit tests but only a reset of IIS fixes it. The library I have authored follows the following pattern:

Entities svc = new Entities(new uri(endpoint));

//do stuff

Am I running out of connections to the web serer doing this? Should I be sharing the DataContext?

Relationship managment

Thu, 26 Nov 2009 09:50:35 Z

Hi,

I'm using EF as a source for DataService.

Some of my entities have many-to-many and one-to-many relationship. Should I always delete, add relationship from both sides or it is not necessary?

Example:

Products has many tags, Tag has many products:

1. context.AddLink(product,"Tags", tag);
context.AddLink(tag, "Products, product);

2. context.AddLink(product,"Tags", tag) - I want to update relationship only from one side. Would it be correct?

Simple query not working with winforms?

Thu, 26 Nov 2009 13:41:05 Z

I am having trouble with a simple query.

I have two tables:

Users
________
UserID (guid)
UserName
...



Websites
_________
WebsiteID (guid)
WebsiteName
WebsiteUrl
UserID
....

I am trying to get a list of websites per user, i tried theese, nothing works but the last which i dont need:

        Dim Service As New Service.ServiceEntities(New Uri("http://******.******.***/Service.svc/"))

        'My.Settings.UserID returns a GUID that corresponds with one row in the DB.
        Dim Query As IQueryable(Of Websites) = Service.Websites.Where(Function(Website) Website.Users.UserID = My.Settings.UserID)
        Dim LinqQuery = From Websites In Service.Websites Where Websites.Users.UserID = My.Settings.UserID Select Websites

        Dim WorkingQuery As DataServiceQuery(Of Websites) = Service.Websites

        WebsitesBindingSource.DataSource = Query
        WebsitesBindingSource.DataSource = LinqQuery
        'Only query that works
        WebsitesBindingSource.DataSource = WorkingQuery

Also ive read that i can do this by adding query options, but i dont know how to construct it so its like the above examples,
Ive tried something like this, but obviously this could not work.

        'Even tried inputing the GUID directly, thinking maybe it could work...
        Dim QueryWithOptions As DataServiceQuery(Of Websites) = Service.Websites.AddQueryOption("$filter", "Users.UserID eq f1bedd51-afd7-4bcf-bbcb-a58b59a29c06")

I dont understand why is the .NET Client Library for ado.net data services so "poor", or i just everything oriented at silverlight.. Am i better of using WCF and doing all the plumbing myself??

VB.NET to C# http://www.developerfusion.com/tools/convert/vb-to-csharp/

datasvcutil error 7015: parameter switch dataservicecollection is not valid

Wed, 25 Nov 2009 12:58:21 Z

I am following the http://msdn.microsoft.com/en-us/library/dd756369.aspx "How to: Manually Generate Client Data Service Classes (ADO.NET Data Services)" topic in order to generate binding classes for ADO.NET Data Service to be used as data source for ASP.NET components like asp:GridView. I am using .NET 3.5 SP1.

The datasvcutil in .NET 3.5 SP1 does not support /dataservicecollection nor /version command line parameters. Therefore it is impossible to generate classes that supports data binding. When datasvcutil from .NET 4 beta is used, then the classes are generated but then they can't be compiled as there is missing EntitySetAttribute within System.Data.Services.Common namespace. According to "http://msdn.microsoft.com/en-us/library/system.data.services.common.aspx" the EntitySetAttribute should be included in .NET 3.5 SP1, but it is not.
Is it here any workaround to actually generate the binding classes and use the ADO.NET dataservice in ASP.NET components with .NET 3.5 SP1 ?

System.InvalidOperationException: The context is not currently tracking the entity.

Tue, 27 Oct 2009 01:51:23 Z

Racking my brain, please help!

I am trying to add a record using ADO.NET Dataservices. Here is my database and code.

table TB_WEB_PROP
column PROP_ID (number) identity
column PROP_NAME (varchar(255))

table TB_WEB_ALERT
column ALERT_ID (number) idenity
column PROP_ID_REL (number) FK is TB_WEB_PROP.PROP_ID

I built an ADO.NET DataModel and exposed using DataServices on the Gateway. The Navigation properties are showing correctly in the Model. I can query the TB_WEB_ALERT object with keys sucessfully. The client is trying to add a record in the TB_WEB_ALERT table, but I cannot get the Foreign Key to work no matter what I try. I have manyc errors like Context Tracking or Null Values in Second, etc.

Here is hte CODE I am using for the update. I suspect it is all in here:, my tables above are condensed versions of the real thing.

        public void InsertAlertRecord(GuestCardObject guestCard)
        {
            TB_WEB_ALERT alert = new TB_WEB_ALERT();

            try
            {
                service = new RESTPropertyEntities(new Uri(configService));

                var propQuery = from TB_WEB_PROP prop in service.TB_WEB_PROP//.Expand("TB_WEB_ALERT")
                                where prop.PROP_ID == guestCard.PropId
                                select prop;

                alert.BATH = guestCard.Bath;
                alert.BED = guestCard.Bed;
                alert.CREATE_BY = "ALERTFORM";
                alert.UPDATE_BY = "ALERTFORM";
                alert.DATE_FROM = guestCard.DateFrom;
                alert.DATE_TO = guestCard.DateTo;
                alert.EMAIL = guestCard.Email;
                alert.ENABLED_FLAG = true.ToString();
                alert.FIRSTNAME = guestCard.FirstName;
                alert.LASTNAME = guestCard.LastName;
                alert.PHONE = guestCard.PhoneNumber;
                alert.PRICE_FROM = guestCard.PriceFrom;
                alert.PRICE_TO = guestCard.PriceTo;
                alert.TERM = decimal.Parse(guestCard.Term);
                alert.TB_WEB_PROP = new TB_WEB_PROP();
                alert.TB_WEB_PROP.PROP_ID = propQuery.FirstOrDefault().PROP_ID;
                service.MergeOption = System.Data.Services.Client.MergeOption.AppendOnly;

                try
                {
                    service.AddToTB_WEB_ALERT(alert);
                    service.AddLink(service.TB_WEB_PROP, "PROP_ID", alert.TB_WEB_PROP);
                    service.SaveChanges();

                }
                catch (Exception ex)
                {
                    throw ex;
                }

            }
            catch (Exception ex)
            {
                LogWriter.Log(2, "Exception Inserting Alert Record", ex);
            }

}

ADO.NET and Web service problem

Wed, 25 Nov 2009 11:44:12 Z

Hi, i have created the following http-endpoint in sql server 08:

create
 ENDPOINT [Tr2] 
		STATE=STARTED
	AS
 HTTP (PATH=N'/sql'
, PORTS = (CLEAR), AUTHENTICATION = (INTEGRATED), SITE=N'localhost'
, CLEAR_PORT = 1099, COMPRESSION=DISABLED)
	FOR
 SOAP (WEBMETHOD 'http://tempuri.org/'
.'Product'
( NAME
=N'[Adventureworks].[dbo].[prProductList]'

, SCHEMA
=DEFAULT
, FORMAT=ALL_RESULTS), 
BATCHES=ENABLED, WSDL=N'[master].sys].sp_http_generate_wsdl_defaultcomplexorsimple]'
, 
SESSIONS=DISABLED, SESSION_TIMEOUT=60, DATABASE
=DEFAULT
, NAMESPACE=N'http://tempuri.org'
, SCHEMA
=STANDARD, CHARACTER_SET=XML
)
go

i then added a web reference to it and try to display the data in the datagrid on click event of a button , with the following code:

localhost.Tr2 ws = new
 tryEmbedded.localhost.Tr2();
dataGrid1.DataSource = ws.Product();

But when it execute no data is return no error too; Can you help me find what im missing;

WCF Data Service problem with complex relationships in db schema

Sat, 21 Nov 2009 15:03:36 Z

I got my WCF Data Service test app working using a simple database schema but it doesn't work when I add some tables to my DataClasses.dbml file. It works for simple parent child relationships but not with ones that have both parent child and collection relationships. For example I have a set of database tables People, Users and Contacts. Both Users and Contacts inherit from People. However I also have a mappings table UserContactMappings, which allows a User to have a collection of Contacts. It seems that the framework treats this collection relationship as inheritence and breaks the service. Unfortunately I can't ake big changes to the schema as there are NHibernate apps that rely on it.

EDIT: Nevermind, I found out what the real problem is. The primary key properies have to be called ID instead of UserID, ContactID, etc. At least it's only the C# property names - the database column names can stay as is. As for the above collection example, well I'm still not sur if that can be done with WCF Data Services or not. Will have to give it a try.

ATOM XML NOT SHOWING IN IE8

Tue, 24 Nov 2009 10:58:53 Z

Hi,

I am using IE8 and VS2008

When I right click my Service.svc file to view in browser, I get the following xml:

<?xml version="1.0" encoding="utf-8" standalone="yes" ?> 
- <service xml:base="http://localhost:2873/ADONetServicesTest/Service.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> 
- <collection href="Authors">
  <atom:title>Authors</atom:title> 
  </collection>
- <collection href="Books">
  <atom:title>Books</atom:title> 
  </collection>
  </workspace>
  </service>

However if I try to navigate to the Author entity using the url I do not see an XML document in the browser.

I see a message asking if I want to subscribe to the feed.

1 - Why am not seeing the atom XML? Do I have to configure IE8 to be able to see the xml?

2 - Do I need to install any tool in IE8 to view the atom XML?

Cheers

C

Returning Entities with Extra Data

Sat, 21 Nov 2009 15:22:42 Z

Trying to figure out the best way to accomplish this. So I have a table of Stores with properties:

StoreID, Name, Latitude, Longitude, etc.

I'm using ADO.NET Data Services to create a web service that will show nearby stores given a radius and a coordinate. I made a Service Operation to take the params and return the results as an IQueryable. So far so good.

So right now I have something like:

return context.Stores.Where(...distance calculation...);

This works great, but I also want to return the distance of each store from the given radius. I have the calculation covered, but how should I include the distance along with the store data? Should I make a class like StoreSearchResult with properties for the Store and the Distance?

If I was just using SQL, I could write a single database query that would return all of the data for the Store, along with a column for the distance. Something like:

Select StoreID, Name, Latitude, Longitude, (calculation...) as Distance 
from Store
where ...distance param...

So I'm looking for the best way to send back the original Store data + the distance calculation while still returning IQueryable. I'd prefer not to take an IEnumerable and use AsQueryable...I just feel like it should be possible to keep it "close" to the database query, and I'm probably just missing something.

Thanks!
Tim

Executing a service operation that returns a primitive type

Mon, 23 Nov 2009 16:10:26 Z

Hi to all, I'm trying to execute this service operation:

[WebGet()]
public int Add(int a, int b)
{
   return a + b;
}

In this way:

int a = 1; 
int b = 2; 

DataServiceQuery<int> query = context.CreateQuery<int("Add") 
.AddQueryOption("a", a) 
.AddQueryOption("b", b);

int s = query.Execute().First();

But I get:

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata  <code></code>
  <message xml:lang="en-US">Bad Request - Error in query syntax.</message>
</error>
">

I have an error if I access to this uri : http://localhost:1135/WebDataService.svc/Add()?a=1&b=2

I must use this other one: http://localhost:1135/WebDataService.svc/Add?a=1&b=2

But I can consume the service operation if it's parameterless:

[WebGet()]
public int Add()
{
    return 4;
}

DataServiceQuery<int> query = context.CreateQuery<int("Add") 
int s = query.Execute().First();

In this way, the value of the integer s is 4.

Could somebody help me, please?

Thanks :)

Title RTM WCF Data Services

Fri, 20 Nov 2009 08:56:08 Z

My last recollection ADO.Net Data Services 1.5 CTP2 was the latest version. Does title imply that there is something newer called RTM WCF Data Services available ? If so could provide the URL please.

Period ('.') character in a KeyPredicate

Tue, 17 Nov 2009 14:11:58 Z

I have a table called User which has an UserPricinpalName as Primary Key.

When I try to get an user with this request :

User us = ctx.User.Where(u => u.UserPrincipalName == userPrincipalName).FirstOrDefault();

I have an error 404 and no request where sent to the database.

After some research, I found that the problem is the '.' character in my param userPricinpalName ('123456789greg.house@serie.us')

http://localhost:58754/FBI.svc/User('123456789greg.house@serie.us')

When I remove the '.' character, I still have an error 404 but it's normal because there is no user matching this param (a request is send to the database).

If I try to use the function Uri.EscapeDataString it doesn't replace the '.' character.

Does anyone have any thoughts as to what might be the problem?

Thanks in advance.

Binding to ComboBox using Astoria v1, EF v1, and Silverlight 3

Fri, 20 Nov 2009 01:36:26 Z

I am using the following technologies: Silverlight v3, Astoria v1 and EF v1. I am having a bit of difficulty showing the value through a ComboBox when the form loads, i.e. nothing is displaying. But when I click on the drop-down arrow, I can see the list that it is bound and select values just fine.

I have a form via a UserControl that displays many properties (for Employee data like FirstName, LastName, Department). The Department is actually stored as DepartmentID and when I hook up EF to it (i.e. create the conceptual model), a property called Departments is created for the class Employee. Any advice will be greatly appreciated.

Here is my XAML code:

---------------------------------------

<UserControl.Resources>
        <DataTemplate
            x:Key="DepartmentTemplate">
            <StackPanel>
                <TextBlock
                    Text="{Binding DepartmentName, Mode=OneWay}" />
            </StackPanel>
        </DataTemplate>
    </UserControl.Resources>

<ComboBox x:Name="cboDepartment"
                    SelectedItem="{Binding Mode=TwoWay, Path=DEPARTMENTS}"
                    ItemTemplate="{StaticResource DepartmentTemplate}" />

Here is my C# code:

void OnControlLoaded(object sender, RoutedEventArgs e)
{
   departments = new Departments(context);
   cboDepartment.ItemsSource = departments ;
   cboDepartment.SelectedItemChanged += cboDepartment_SelectedItemChanged;
   cboDepartment.GetData();
}

void cboDepartment_SelectedItemChanged(object sender, PropertyChangedEventArgs<object> e)
{
   Employee emp= DataContext as Employee;
   Department dept = cboDepartment.SelectedItem as Department;
   context.SetLink(emp, "DEPARTMENTS", dept);
}

Deleting of Many To Many relation problem.

Thu, 19 Nov 2009 05:07:42 Z

Hi,

I'm using NHibernate as custom datacontext.

When I perform delete of many to many assotiation i've got an exception in GetResource method of datacontext.

I wonder why ADO.NET Data Services tries to get entity which link is deleted using following query:

{value(NHibernate.Linq.Query`1[Domain.News]).Where(element => (element.NewsID = 1)).SelectMany(element => Convert(element.Tags)).Where(element => (element.TagID = 1))} - this query is fail to execute in GetResource method, because NH have poor support of selectmany.

News has many tags. Here I have deleted link on Tag from News.

But I think that query should be simply Select tag by Id.

Exception When Saving

Mon, 16 Nov 2009 11:18:22 Z

Hi,

I am receiving the dreaded "Non-static method requires a target" exception when calling the SaveChanges method on a proxy to a Data Service.

The entity I'm trying to save was added to its respective collection through the AddObject method, and it does show up in the Entities collection. I have also added a link, through the AddLink method, that relates it with another object which is associated with the entity I'm trying to save.

What could be the cause, any clues?

Thanks,

Ricardo Peres

Connection to remote database

Tue, 10 Nov 2009 04:45:27 Z

hi,
I am trying to connect to a remote database server using ADO.NET data services.
I can sucessfully create the EDM from existing table and even i can browse the data service from visual studio by 'View in Browser' option.
But when i publish the data service on IIS, i am unable to browse the data service. It throws an error saying 'Login failed for my machine name' .
Am i missing out on some setting ?

Thanks,
Avani

What's the best way to manage context in an ADO.NET Data Services call?

Wed, 18 Nov 2009 16:34:17 Z

We need to store the user's authentication and profile information at the beginning of the request and access it in various places (think: QueryInterceptors.) Note that we obviously would only want to persist this data across one request. Where is a legitimate place to store this data and access it later? Do we have access to HttpContext? How about Thread Local Storage? Does CallContext work? Any help would be appreciated. Thanks!

CRUD operations for Foreign key relationships

Fri, 21 Aug 2009 13:21:37 Z

hi,
Can someone please tell me how are the CRUD operations performed, when a table has foreignkey relationships ?
Any tutorials/codesnippets available for that ?

Thanks in advance,
Avani

JSON date isn't UTC

Fri, 29 Aug 2008 18:37:09 Z

--------------

If I retrieve a JSON payload from an ADO.NET Data Services service, a date is returned as:

/Date([ticks])/

There is no consideration of timezone or UTC. The date value arrives as is with no change in offset from the datetime field value in SQL Server.

If I create a Date object in JavaScript passing [ticks] to the Date constructor, JavaScript assumes UTC ticks and adjusts accordingly. Of course I could store UTC dates in SQL Server which is better in many situations anyway.

--------------

If I create a WCF method that returns a JSON payload and that method:

- Performs a Linq to SQL (not EF, as with ADO.NET Data Services) query that retrieves the same datetime value from SQL Server

- Returns the datetime value as a DateTime type within a DataContract object

...the date is returned as:

/Date([ticks][+/-UTC offset])/

Then, if I create a Date object in JavaScript, the expected UTC adjustment produces a correct local time.

--------------

1) Is there any way to get ADO.NET Data Services to return the UTC version of the JSON date as WCF does?

2) Is ASP.NET Ajax built to handle these differences automatically? I'm using ExtJs so I haven't tested this one.

3) Does the JavaScript Date object handle some of these differences? I'd guess no since, correct me if I'm wrong, the "/Date.../" format is Microsoft proprietary.

Thanks...

Named Pipes Error

Tue, 13 Oct 2009 16:09:32 Z

I setup an ADO.NET Data Service and it works fine locally. I deployed it to my server with the correct Connection string and parameters. I'm getting a SQL Named Pipes error (see below)

Is there anything else I need to do to the client or the server?

Thanks,
Robert

<?xml version="1.0" encoding="utf-8" standalone="yes" ?>

- <error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">

<message xml:lang="en-US">An error occurred while processing this request.</message>

- <innererror xmlns="xmlns">

<message>The underlying provider failed on Open.</message>

<type>System.Data.EntityException</type>

<stacktrace>at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure) at System.Data.EntityClient.EntityConnection.Open() at System.Data.Objects.ObjectContext.EnsureConnection() at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() at System.Data.Objects.ObjectQuery`1.GetEnumeratorInternal() at System.Data.Objects.ObjectQuery.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()</stacktrace>

- <internalexception>

<message>A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)</message>

<type>System.Data.SqlClient.SqlException</type>

<stacktrace>at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)</stacktrace>

</internalexception>

</innererror>

</error>

ado.net data service very poor perfomance

Mon, 16 Nov 2009 03:46:02 Z

Hi

I am testing on ado.net data service. I just created web application with SQL server there is one table and about 900 rows in database table.
After building application i just test to get all entities from web browser. but it takes about 5 or 6 minutes to get all data in internet webbrowser
I don't know this is normal situation or not. source table only has 5 columns.
Do I miss something ?

Regards,
Park

anyway to suppress error on relationship checking on mapped dummy stored procedure/function

Sat, 14 Nov 2009 17:12:19 Z

my applicaiton does not allow delete on certain tables, furthermore, some table that has attributes that is used within the table despite some FK are used to constraint the values
these FK constraint becomes liability during mapping for some update store procedure: producing tons of errors for not dealing with relationships. same goes for delete store procedure

the way it is I lost all advantages that canb e gained from edm on ado.net Furthermore I need some visual display of data anyways. I was hping I can use the entity to update in the datridview and hence reduing the amount of manaul mapping of stored prcedure mapping.

Did go off in a tangent. I was trying to follow some of
http://social.msdn.microsoft.com/Search/en-US?query=how%20to%20use%20linq%20on%20ado%20.net%20entity%20model&refinement=112&ac=8
http://msdn.microsoft.com/en-us/library/bb738488.aspx

Clarification needed on Edm.Decimal

Sun, 08 Nov 2009 18:32:21 Z

in The CSDL, document, the Decimal is described as

"2.2.1.7 Decimal
The Decimal type represents numeric values with fixed precision and scale. The required precision and scale can be specified using its optional Precision and Scale facets. This type can describe a numeric value ranging from negative 10^255 + 1 to positive 10^255 -1."

However, in the APDSU, Decimal is defined as
decimalUriLiteral = decimalLiteral
("M"/"m")
decimalLiteral = sign 1*29DIGIT
["." 1*29DIGIT]

Somewhere I have read decimal uses 96 bits, so 29DIGIT makes sense. Can someone clarify the range of "negative 10^255 + 1 to positive 10^255 -1."? Thanks!

DataSet in SilverLight, what to replace?

Thu, 21 Aug 2008 19:19:40 Z

Our software uses DataSet to send/receive data using WCF and consume it in the Windows Forms. But now we want to move to SilveLight, or use it in some areas to show the data on the web without using ASP.NET. But I noticed that SilverLight does not accept DataSet! This creates the problems for us, because DataSet is used in these parts! Now, what do you think is the bset way?

Thank you for your help in advance.

Mike

Bad Request - Error in query syntax

Mon, 09 Nov 2009 16:09:18 Z

Hi,

When I use the CreateQuery to call a webget function on the server, I get "Error in query syntax". However the call is being made and processed on the server without problems. Only on the client that result can somehow not be processed.
When I use context.Execute(url) then it all works. I need to use the CreateQuery.
Any ideas?

(VS2010 Beta2)

Client Code that does not work:

DataServiceQuery dsquery = searchEntitiesContext.CreateQuery<BusinessEntitySearchResult>("BusinessEntitySearch")
    .AddQueryOption("searchText", "'a*'").AddQueryOption("maxCount", "10");
var list = dsquery.Execute();

Client code that works:

IEnumerable<BusinessEntitySearchResult> list = searchEntitiesContext.Execute<BusinessEntitySearchResult>(new Uri(query, UriKind.Relative));

Server code:

[System.ServiceModel.Web.WebGet]
public ObjectResult<BusinessEntitySearchResult> BusinessEntitySearch(string searchText, int maxCount){
String userName = string.Empty;
    if (System.Web.HttpContext.Current != null && System.Web.HttpContext.Current.User != null && !string.IsNullOrEmpty(System.Web.HttpContext.Current.User.Identity.Name)) {
      userName = System.Web.HttpContext.Current.User.Identity.Name;
    }
    ObjectResult<BusinessEntitySearchResult> searchResult = (new FullTextSearches()).BusinessEntitySearchInternal(searchText, maxCount, string.Empty, CurrentDataSource, userName);
    return searchResult;
}

EntityReference not accessible

Tue, 10 Nov 2009 08:10:09 Z

I'm try to access the automatic generated EntityReference attribute for an object created by EDM. I can access the object "FaxCountry" itself without problem. However, when I try access the "FaxCountryReference" it is neither visible in the browser window (even if the BrowsableAttribute is changed to true) nor compiled by the compiler.

Does anyone have any thoughts as to what might be the problem?

Thanks in advance.

        /// <summary>
        /// There are no comments for FaxCountry in the schema.
        /// </summary>
        [global::System.Data.Objects.DataClasses.EdmRelationshipNavigationPropertyAttribute("RTE.FBI.Model", "FK_SubscriptionData_Countries", "Country")]
        [global::System.Xml.Serialization.XmlIgnoreAttribute()]
        [global::System.Xml.Serialization.SoapIgnoreAttribute()]
        [global::System.Runtime.Serialization.DataMemberAttribute()]
        public Country FaxCountry
        {
            get
            {
                return ((global::System.Data.Objects.DataClasses.IEntityWithRelationships)(this)).RelationshipManager.GetRelatedReference<Country>("RTE.FBI.Model.FK_SubscriptionData_Countries", "Country").Value;
            }
            set
            {
                ((global::System.Data.Objects.DataClasses.IEntityWithRelationships)(this)).RelationshipManager.GetRelatedReference<Country>("RTE.FBI.Model.FK_SubscriptionData_Countries", "Country").Value = value;
            }
        }
        /// <summary>
        /// There are no comments for FaxCountry in the schema.
        /// </summary>
        [global::System.ComponentModel.BrowsableAttribute(false)]
        [global::System.Runtime.Serialization.DataMemberAttribute()]
        public global::System.Data.Objects.DataClasses.EntityReference<Country> FaxCountryReference
        {
            get
            {
                return ((global::System.Data.Objects.DataClasses.IEntityWithRelationships)(this)).RelationshipManager.GetRelatedReference<Country>("RTE.FBI.Model.FK_SubscriptionData_Countries", "Country");
            }
            set
            {
                if ((value != null))
                {
                    ((global::System.Data.Objects.DataClasses.IEntityWithRelationships)(this)).RelationshipManager.InitializeRelatedReference<Country>("RTE.FBI.Model.FK_SubscriptionData_Countries", "Country", value);
                }
            }
        }

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

Mon, 09 Nov 2009 22:32:20 Z

I would like to know what the best practices are for utilizing and exposing DTOs in an ADO.NET Data Service. 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. 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 this method, I get the error:

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

here is the service operation:

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

Slow Performance from Silverlight

Mon, 12 Jan 2009 16:16:15 Z

Hello,

We are experiencing very slow CRUD operations using ADO.NET data services from Silverlight. Our model has about 350 entities. The response times are in the area of 1-2 minutes.

Substituing our production model for a small test model, the reponse times are fine.

In both scenario's, the executed code is the same and mirrors that of the Silverlight ADO.NET Data Services documentation. Our database doesn't have much data in it, so I don't believe that is the cause of the issue.

Is anyone else working with large models and experiencing this behavior?

Thanks,
Jeff

Support for count (and other aggregations) in projections?

Mon, 09 Nov 2009 21:15:28 Z

I was wondering if there is going to be any support for $count (or some other syntax) that would allow aggregations when projecting on an entity. For instance, if I had a Customer entity that had a list of Orders, would it be possible to only get the Id, Name, and Order count of each Customer? This would be immensely useful!

Upload files?

Wed, 16 Jul 2008 04:39:23 Z

Hi Guys,

Is it possible to upload files either via Entities or ServiceOperations? If so can you point me at some documentation or an example of how it's done?

Thanks,
Michael

Nullable Foreign Keys

Mon, 26 Oct 2009 15:47:34 Z

Hi there,

We've got the following (for explanatory reasons simplified) situation. There is an Order table and an Items table and between those there's a foreign key relationship defined. The foreign key column on the Item table does allow null values so Items may exist without an Order. Creating this relationship:

Order 0..1 --<> * Item

For example, there are 2 Items in the database, one belonging to an Order and another one standing on its own (i.e. has a null value in the foreign key column). Now when i do a request for the one belonging to an Order like this:

http://localhost:4717/WebDataService1.svc/Items(1)/Orders

I get the parent Order as result back from the service which is logical as there is a valid foreign key relationship. Now when i do a request for the unrelated Item like this:

http://localhost:4717/WebDataService1.svc/Items(2)/Orders

I won't get a response at all. The server returns just nothing, like it is hanging. Shouldn't the server at least return something? Like when you query for Items for an Order which has none you at least get an empty result back which you can handle in your application...just hanging there seems so useless ;-)

I hope i'm clear enough

Note: This a readonly DataService

Thanks,

E

UpdateEntity with rebinding link

Wed, 16 Sep 2009 22:37:44 Z

In the APDSU spec 2.2.7.3.1 UpdateEntity Request section, it says the user can rebind the link using the UpdateEntity request.

I am trying to rebind the link of Territories('60001') to region to Region(7001), but it doesn't works. When I issue a get entity request, the Region associated with the Territories('60001') is still Region(6001).

Here is my put request.

PUT //NorthwindWeb/NorthwindDataService.svc/Territories('60001') HTTP/1.1

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<entry xml:base="http://host:port/NorthwindWeb/NorthwindDataService.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">
<category term="NorthwindModel.Territories" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
   <link rel="related/Region" href="http://host:port/NorthwindWeb/NorthwindDataService.svc/Region(7001)"/>
<content type="application/xml">
    <m:properties>
      <d:TerritoryDescription xml:space="preserve">Territory 003                             </d:TerritoryDescription>
      <d:TerritoryID>60001</d:TerritoryID>
    </m:properties>
</content>
</entry>

Did I miss something? Thanks.

SaveChanges() throws exception: The response to this POST request did not contain a 'location' header. That is not supported by this client.

Fri, 06 Nov 2009 18:46:40 Z

Hi there,

I'm trying to insert a new record into 'A160Pedimentos' table.

public void ProcesaDS()
        {
            var proxy = new IntermediaEntities(new Uri("http://myserver/MyDataService.svc/"));

            var pedim = new A160Pedimentos
            {
                fechapago = DateTime.Now,
                clavecliente = "0001",
                firmapago = "FIRma"

            };

            proxy.AddToA160Pedimentos(pedim);
            proxy.SaveChanges(); // Exception here
        }

Problem is... proxy.SaveChanges() throws the following exception:

System.NotSupportedException was unhandled
  Message="The response to this POST request did not contain a 'location' header. That is not supported by this client."
  Source="System.Data.Services.Client"
  StackTrace:
       at System.Data.Services.Client.DataServiceContext.SaveAsyncResult.HandleOperationResponse(HttpWebRequest httpWebRequest, HttpWebResponse response)
       at System.Data.Services.Client.DataServiceContext.SaveAsyncResult.BeginNextChange(Boolean replaceOnUpdate)
       at System.Data.Services.Client.DataServiceContext.SaveChanges(SaveChangesOptions options)
       at System.Data.Services.Client.DataServiceContext.SaveChanges()
       at Pedimentos160.Procesar.ProcesaDS() in C:\Pedimentos160\Procesar.cs:line 121
       at Pedimentos160.Program.Main(String[] args) in C:\Pedimentos160\Program.cs:line 17
       at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
       at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
       at System.Runtime.Hosting.ManifestRunner.Run(Boolean checkAptModel)
       at System.Runtime.Hosting.ManifestRunner.ExecuteAsAssembly()
       at System.Runtime.Hosting.ApplicationActivator.CreateInstance(ActivationContext activationContext, String[] activationCustomData)
       at System.Runtime.Hosting.ApplicationActivator.CreateInstance(ActivationContext activationContext)
       at System.Activator.CreateInstance(ActivationContext activationContext)
       at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssemblyDebugInZone()
       at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading.ThreadHelper.ThreadStart()
  InnerException:

Can someone please help?

Regards,

-Jorge

Feature request, expose known data-types

Tue, 29 Sep 2009 08:26:07 Z

Hi,
I have a requirement at the moment to publish webcal calendars from event data that is stored in a database. A webcal calendar is, as I understand it, little more than a datafeed in a well-known format (although admittedly that format isn't XML). I should say I'm by no means an authority on webcal at the time of writing.

It occurred to me that there is nothing in the MSFT stack that makes this is easy to do and it further occurred to me that perhaps ADO.Net Data Services might be a good fit seeing as publishing data on the web is its raison d'etre.

Hence, a feature request:
Please give ADO.Net Data Services the ability to publish data in well-known data formats. My motivator for this is webcal data but I suspect that are multitudes of data formats that would fit very well for this feature (e.g. microformats).

THoughts?

thanks
Jamie

http://sqlblog.com/blogs/jamie_thomson/ | http://jamiethomson.spaces.live.com/ | @jamiet

JSON format of some number types are stored in double quote?

Thu, 05 Nov 2009 17:57:20 Z

In the 2.2.6.3.1 section of APDSU spec, the JSON serialization format of the following number types are stored in a double quotation:

Edm.Decimal jsonDecimal
Edm.Double jsonDouble
Edm.Int64 jsonInt64
Edm.Single jsonSingle

However, from our testing, only EMD.Int64 value are stored in "". The other three types do not have "" around it.

Can you verify this? Is this because the spec is wrong? Or the implementation is wrong?

Thanks!

DataServiceContext stored in session - cannot serialize

Wed, 28 Oct 2009 18:40:51 Z

We have an application that uses the ADO Data services. The use of these services has been great and really helped us develop our product quickly. What we have been doing, though, is storing our dataContext in Session of our ASP.NET app. Each session (user) gets their own copy of the dataContext which makes for less trips as it is caching the information and retrieving it only once.

This has worked great for us, until now. We have a need to push Session out to Sql Server and therefore need to make sure that all our classes are Serializable. I am able to make most of the classes this, including my dataContext class, however since it is inheriting from DataServiceContext, it fails. DataServiceContext is not serializable.

Any ideas on what to do here. I was hoping to keep the dataContext in Session, however it's not looking good. That will cause me to rewrite a bunch of code and will definitely cause multiple trips to the database and back if I can't keep it in Session.

I appreciate any and all help on this.
Matt

Load testing the Data Services

Wed, 14 Oct 2009 07:16:01 Z

Can anyone suggest a simple way to load test DataServices?

Support for SQL 2005

Tue, 03 Nov 2009 17:17:33 Z

I am writing a small product for the banking industry. The product will be sold to customers who would be running SQL 2005 or SQL 2008.

I need to expose some of my database objects (tables / views / stored procedures) as web services.

I am ready to baseline .NET framework 3.5 to run the web services... but the database can be either SQL 2005 or 2008.

Can you please confirm if I can use ADO.NET Data Services? or will I have to write web services manually?

Regards,
Abhishek