.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

.net 2010 REST WCF - json does not return the root List type

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :ASP.Net


I am using the .net 2010 WCF Rest Service Application template to create my services.

The service needs to support two return format - xml and json which 2010 easily handles by changing the Accept value in the header info.

I have the following class structure

   public class ri
        public string nm { get; set; }

        public string nval { get; set; }

        public string cnt { get; set; }

    public class r
        public string val { get; set; }

        public string nm { get; set; }

        public List<ri> ri { get; set; }

   public class refinements
        public List<r> refs { get; set; }

   public class GetRefinementsSvc
        [WebGet(UriTemplate = "")]
        public refinements GetCollection

View Complete Post

More Related Resource Links

How to use return JSON object from web service as a declared Type?

Hi, I just hit the following issue: I am calling a web service that returns a serialized JSON object let's say: __type, FirstName, LastName (.net object Person with properties FirstName and LastName). __type's value is Test.Person I have created a JS object using Type.registerNameSpace/registerClass called Demo.Person and it is registered on the page using the ScriptManager. Everything is working fine; I am able to get data from the server on the call back. Is it possible to make the returned object from the web service be an instance of the declared JavaScript Demo.Person class? The idea would be to call a method like result.getFullName() on the client side without having to copy all the properties. This is just a simple scenario for more complex objects.   Thanks,   Teo

ListData.svc fails if list has calculated column with Yes/No (boolean) return type


I have a list with a calculated column whose return type is Yes/No.  If I try to browse to the list or a list item using REST via ListData.svc, I get the error "An error occurred while processing this request".  Can't seem to find anything in 14\LOGS or the System or Application event logs.  I've tried multiple calculation formulas such as:



Both display "Yes" when viewing through the SharePoint UI and are sortable and filterable.  If I change the calculated column return type to anything else (single line of text, currency, date/time, etc.) and update the formula as necessary, ListData.svc displays the list item XML as expected.  If I replace the calculated column with a regular column whose type is Yes/No, ListData.svc displays the list item XML as expected.

Is this a known bug?  Is there a workaround (other than manually casting to bool in my code)?

How to add a auto genterated column in a sharepoint list of type number in SharePoint 2010


am try to generate a auto increment column for my SharePoint list of type number type?

=TEXT(1000+ID,0) , when i use this formula it works some time and some time it doesn`t increment?


do you know any out of box way to do this?

Thanks in Advance

Share Knowledge and Spread Love!

How to return a generic list in json format


Hi how would i go about returning a generic list in json format, can anyone point me to any good examples. Thanks

How exactly does a SharePoint 2010 External Content type / list work?



I'm trying BCS on an SQL table which contains about 300,000 rows. Following is what I've observed:

1. A "SELECT * FROM <TABLE>" query fired on the SQL Table using SQL Management Studio returns all the result in 12 seconds
2. The same data when accessed by browsing the default view of external list (to which an External Content Type (ECT) built over the same SQL table in SharePOint Designer 2010 is attached) takes about 3:14 minutes

If I edit the ECT (using SharePoint Designer) and set limit as 100,000, it takes about 49 seconds to load, and further reduction in limit reduces the time to load.

My questions are:

1. What is it that causes so much delay in accessing the rows, as SQL delivers them in 12 seconds? Can anyone please help me understand the BCS / ECT architecture- how it accesses data, etc.
2. Can I implement paging in ECTs created using SharePoint Designer 2010?

Any help shall highly be appreciated. Thans in advance!


Custom list -- control issue with column type "Choice" and Infopath 2010

I finally got our project lead to abandon external SQL lists, so now I've created custom lists in SP 2010. I have some columns that are of "Choice" type/"Display as radio buttons" (customer requirement). When I start Infopath 2010 locally and create the data connections to the list(s), those choice fields display in I/P as dropdowns. If I change the control with a right-click to "Option Button", I only get one -- I need 2 (yes, no) or, in a few upcoming cases 3 or 4. BTW, same with changing the control to a check box -- only get 1. FWIW, I get the same results if I start Infopath directly from the list in SP Designer 2010. Any ideas?
Joel W. Johnson

Need Syntax To Make Results of LINQ Union Return Non-Generic Type



I have the below SQL which works just fine:

SELECT     Message, CreateDate, AccountId, AlertTypeId
FROM       dbo.Alerts
SELECT     TOP (100) PERCENT Status, CreateDate, AccountId,
                          (SELECT     10 AS Expr1) AS AlertTypeId
FROM         dbo.StatusUpdates
WHERE AccountId = PassedInParameter

I have been going about trying to convert the above into a LINQ method and am having problems with return types.
As the above SQL illustrates, I am querying two distinct LINQ tables - Alerts and StatusUpdates -
and then attempting to perform a Union on them. In order to do the union in LINQ, I have to have agreeing types. So, I
am using "var" to make the results of "alerts" and "updates" generic before the union.  

public IList GetStatusUpdatesAsAlertsByAccountId<T>(Int32 accountId)
            using (WorkbookDataContext dc = _conn.GetCont

Issue with List Definition of same base content type and deployed via same feature


I am trying to deploy two custom list definitions using only one single feature.  Below are the details of my issue.

  • Two custom list definitions
  • Each custom list definition has its own custom content type
  • Each custom content type inherits from the base content type Picture (Type = 109)
  • The custom list definitions are grouped together under one single feature
  • The custom content types are grouped together under a seperate single feature

When I deploy my solution in this configuration, the second list definition gets the first custom content type applied to it and the list schema from the first list definition is also applied to the second list definition.

What makes this more interesting, when I seperate both of the list definitions under two seperate features it all works fine.  Custom content types and list schemas get applied correctly.

Can anyone tell me why I can not deploy both list definitions under one single feature?

If you need me to post any of the origional code or XML to this post please let me know.



Creating SharePoint Server 2010 External Content Type Associations with SharePoint Designer 2010

Learn how to use Business Connectivity Services (BCS) to create associations between external content types in SharePoint Designer 2010 without using code.

Quick Note: Create Custom List Definitions in SharePoint 2010

In this exercise, you create a custom list definition in Microsoft SharePoint 2010 and then create an event receiver that is triggered when the list is used.

Video: List Relationships and Joins in SharePoint 2010

The SharePoint lookup field allows you to connect an identifier of one list and to display a different, friendlier field - such as name - for users to select. SharePoint 2010 adds the ability to create additional columns that display other fields from another list. (Length: 10:46)

Video: Large List Support in SharePoint 2010

SharePoint 2010 has support for very large lists of up to 50 million items. With this expanded list size comes the ability to throttle and control how much data is returned to the user and prevent large queries from compromising the SharePoint farm. (Length: 15:36)

Video: Field and List Item Validation in SharePoint 2010

SharePoint supports the ability to create Excel-like field validation formulas to validate field data in a list, which greatly reduces the amount of custom code that a developer must create and deploy. (Length: 1:44)

Video: Accessing SharePoint 2010 List Data

In this video you will learn how to create strongly typed classes using a tool called SPMetal to do LINQ programming against a SharePoint 2010 list. (Length: 15:22)

Video: SharePoint 2010 Lists, List Data, and CAML

This demonstration illustrates how to work with list data and the Collaborative Application Markup Language (CAML). (Length: 5:05)

VS 2010 XAML Design View Load always fail with a Type Load Exception

Create a new WPF project in VS and change nothing. The Design View will fail to load with the error below. Error    1    Could not load type 'Microsoft.Expression.DesignModel.Core.ISharedInstanceBuilder' from assembly 'Microsoft.Expression.DesignModel, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. Microsoft.Expression.DesignModel is an assembly from Expression Blend. I ever installed Blend 4 RC and uninstall and install Blend 4. I Reflector the assembly I have under Blend 4 bin folder. And cannot find a interface named ISharedInstanceBuilder. But the WPF project is a Template project without any changes. How it get related with Blend 4? And how to fix it? Thanks.  

How to return back to a specific page in a gridview list?

Hello,  I have a gridview with paging. So for instance, I'm on say the page number 10, and I open the form details on a specific record_id (link). After I update/submit the form, it returns to page number 10. But, if I go to another page, for instance page 5, and submit the form, it returns to page 10. I've tried some things, for instance history.back(), but it returns to the first page I went to, in this case page number 10 (or whatever the first page I go to). Hopefully this code helps to understand what I'm asking: <asp:GridView DataKeyNames="Referral ID" ID="gvList" runat="server" CellPadding="4"     ForeColor="#333333" GridLines="None" OnRowCommand="gvList_RowCommand"     OnRowDataBound="gvList_RowDataBound" OnRowDeleted="gvList_RowDeleted"     OnRowDeleting="gvList_RowDeleting" AllowPaging="True" PageSize="20"     AutoGenerateColumns="False" OnPageIndexChanging="gvList_PageIndexChanging"    OnRowCreated="OnRowCreated" AllowSorting="True" OnSorting="OnSort"> protected void gvList_PageIndexChanging(object sender, GridViewPageEventArgs e)        {   &nb
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend