Using Domain Service with ASP.NET Dynamic Data

re: Using Domain Service with ASP.NET Dynamic Data

MarkLIu10 — Mon, 25 Oct 2010 15:53:01 GMT

Thank you very much. I got it.

Another problem: Following your blog, I just created an ASP.NET Dynamic Data Domain Service Web application without adding any other code. There is no any problem doing “Edit”, “Update”.

Then I create the same application, but using table “Employee” of “AdventureWorks” database. After display “Employees”, I click “Edit”, modified a “Title” column. But I got following error after click “Update”.

Cannot insert duplicate key row in object 'HumanResources.Employee' with unique index 'AK_Employee_rowguid'

But no such error in a Dynamic Data Entity Web application.

What’s wrong? I didn’t add any code.

re: Using Domain Service with ASP.NET Dynamic Data

pranav rastogi — Sun, 24 Oct 2010 02:14:13 GMT

The reason you get this exception is that you have multiple Query methods and Dynamic Data need to know which one to use so you have to make one as the default query method. eg

[Query(IsDefault =true)]

GetProductsCustomSorting()

More info about the attribute msdn.microsoft.com/.../system.servicemodel.domainservices.server.queryattribute(v=VS.91).aspx

re: Using Domain Service with ASP.NET Dynamic Data

MarkLIu10 — Sat, 23 Oct 2010 17:35:31 GMT

I first create ASP.NET Dynamic Data Domain Service application, which connect to NorthWind Database. It works like usual. Then following your sample code to add IQueryable<Product> method:

“public IQueryable<Product> GetProductsCustomSorting(string sortBy)”

But run default.aspx gets error

“Cannot find the default query method for type ‘XXX(my type' in the domain service ‘XXXService(My service)'. When a type has multiple query methods associated with it then one of them must be marked as the default one using QueryAttribute.”

Why? How to set default query method?

re: Using Domain Service with ASP.NET Dynamic Data

pranav rastogi — Mon, 11 Oct 2010 09:46:20 GMT

Unfortunately I do not have CodeSample handy at this point and would have to build one. You can do Custom buk operations within the domain service as well eg you can put this in Update for Northwind Products which updates all product rows based on a condition

public void UpdateProduct(Product currentProduct)

{

IQueryable<Product> result= this.ObjectContext.Products.Where(p=>p.UnitsInStock<10);

try

{

foreach (Product item in result)

{

item.Discontinued = true;

}

try

{

// Try to save changes, which may cause a conflict.

int num = this.ObjectContext.SaveChanges();

}

catch (OptimisticConcurrencyException)

{

// Resolve the concurrency conflict by refreshing the

// object context before re-saving changes.

this.ObjectContext.Refresh(RefreshMode.ClientWins, result);

// Save changes.

this.ObjectContext.SaveChanges();

}

catch (UpdateException)

{

}

You can also refer to the following sample which shows how you can do edits on multiple rows using gridview www.codeproject.com/.../BulkEditGridView.aspx

You would have to extend this sample to work with Domain Service

In general I would say that you should use Domain Data source server control if you want to use the Databound controls, but if you do not want to use the control then you could do something as follows.

Following post shows how you can use DomainService with MVC

blog.bmdiaz.com/.../using-ria-domainservices-with-asp.net-and-mvc-2.aspx

You can follow the same pattern for creating a domainservice and then bind it to the Gridview without using the DataSource

re: Using Domain Service with ASP.NET Dynamic Data

Don — Fri, 08 Oct 2010 04:50:11 GMT

Well basically how to consume the DomainService programmitcally in an ASP.NET page other than just using the DomainDataSource control. An example and an explanation would go a long way. Do you have any samples I could see? I am just trying to get past this one last hurdle...also do you need to do anything special to instantiate the DomainService in ASP.NET code behind? I'm not sure whether I am instantiating the service correctly....

re: Using Domain Service with ASP.NET Dynamic Data

pranav rastogi — Thu, 07 Oct 2010 06:03:37 GMT

@Don: You are correct in your understanding. The Domain service scenario works differently in Aspnet application vs Silverlight. In AspNet there is no Client generated so you are working with the Domain Service directly. And when you use Databound control with DomainDatSource, you are limited to a single row update by default. That being said you can have a CustomUpdate method fired in the DomainService which could update more than 1 row of the entity provided that you handle the SaveChanges(). Following linek shows you how to use SaveChanges msdn.microsoft.com/.../bb336792.aspx

Regarding documentation we have something in works which would add to the existing ones and I would like to hear from you on what is missing currently.

re: Using Domain Service with ASP.NET Dynamic Data

Don — Wed, 06 Oct 2010 16:13:09 GMT

So I wanted to implement a "bulk" insert in my domain service. I am using Dynamic Data and ASP.NET...all the domain service examples I have seen refer to using Client generated Object Context class in SIlverlight examples...I'm guess this isn't applying to my case since all the processing I am doing with DD is happening server side....so would i just add my custom bulk methods to my Domain Service class and add the <ignore>_ attribute...is this save? Also would I explicistly have to call SaveChanges() ? The docs for Silverlight are good but as this applies to Dynamic Data and ASP.NET I have to save only very basic examples are covered....

Using a DomainService in ASP.NET and Dynamic Data

Angle Bracket Percent — Fri, 27 Aug 2010 00:11:45 GMT

Update (8/26/2010): I updated some of the content to reflect the new way to get the bits. One