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

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

Best Practice for writing DataContract for a multi row data set.

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :WCF

My Stored Procedure returns the following fields: DisplayName, CompCode, CompName, CompValue, CompFlag. For any caseid there may be multiple rows returned.

I want my WCF Web Service to  expose all the above mentioned fields in wsdl.

How should I write my DataContract so that the xml has multiple rows.

Is it ok to to put List<string> in DataMembers as shown below or is there another best practice?

        public List<string> DisplayName { get; set; }


Thanks You.


View Complete Post

More Related Resource Links

Writing Data to database with jQuery Forms, ASMX Webservice, & JSON - help!



Can someone point me in the right direction on how to submit data from a jQuery form to a ASMX webservice? I have gotten everything on the form ready to be submitted to the database and now I am stuck on how to send it over using $.ajax(). Everything I have read tells me how to get data from a webservice and display it with jQuery, but not the other direction nor how to access the json data within the within the webservice service(similar to a Request.Form approach with ASP.NET forms).

In other words: 

1. What do I need to do to my webservice to make sure it can receive data from the jQuery form. 

2. What do I need to do in jQuery to receive an acknowledgement the save on the server side was successful. 

I can explain more if need be, but if there is a comprehensive tutorial on not only reading, but also WRITING data with jQuery, JSON, etc. I would love to get pointed in that direction. 

Use BDC data in list as multi-select column

I have a document library that uses values from another system for its metadata.  Right now, we copy the values from the primary system into SharePoint so users can choose them.  I want to find a way to use the BDC connection that I have set up to automatically pull those values.  The problem is that the current metadata is set to multi-select.  So, I have a file that is in the library and it can be used for multiple clients - clients is a column in my library and users can select many entries.  When I set up a column to pull BDC data, it only allows single entry.  Does anyone have any ideas?

Best practice? Accessing subset of data based on user


I have a DB and associated Asp.net 3.5 web app. The database holds information on our clients. We're adding client access functionality and I need to know how best to restrict user access to data only pertaining to their client.

The clients are stored in a hierarchy and each user can be associated with multiple clients. The user should only be able to access the data for their associated clients and any sub clients thereof.

My initial thought is to add a collection of clients to their profile, then use that to filter all queries; however, my gut instinct tells me that using the profile for such a security function is inadvisable.

Could anyone provide any insight on a best practice for this? I'm sure it must be a pretty common need.


Writing the windows forms data to an HTML file

I have a windows forms application ready now i need to transfer data from the windows forms to the web and to do this i need to write an HTML file that contains the form data, i mean the data contained in the form should be written to an HTML file to be submitted and this HTML file should be generated on the local PC. I have the code for the HTML file but how can i write this HTML file with the data values contained in my windows forms. Please give your suggestions. Best Regards, Syed

Share Point Designer 2007 Workflow (Sequential) - multi-collect data from user

I am currently building a multi-step workflow using ShrePoint designer for MOSS2007. I am getting a bit confused as to if I have an error or if I am doing something incorrect. Here is what I have going. My workflow consists of something similar to the following New document comes in, a collect data from user routine is ran and assigned to a reviewer. My understanding when I create a collect data from user WorkFlow step is any data I request is saved in the "Tasks" list. Therefore I need to grab the workflow task ID in order to later lookup what the reviewer submitted... I understand this...   However, I have one more collect data from user workflow step and I have one more item to collect. Even though this is a brand new collect data from user workflow step - does the collected data still go into the "Tasks" list? In other words, if I have two steps in a workflow and both of these steps are "collect data from user", does the data from both steps go into the same "Tasks" list?  I could see how this might be possible as long as the Task list columns contain all the items for all the different "collect" data from user steps.  I don't see two different Tasks lists representing or named "Reviewer" or "Final" or anything, so I assume the items are all in "Tasks"   However..

Is it a good practice to use DataContract attributes on business entities

Hi Folks, Currently I am developing a framwork for travel industry and finally my framework will expose its operations in the form of WCF Service. I was wondering if it is a good idea to decorate your entities and class with DataContract attributes. I know this is required if you want your classes/fields to be serialized/deseralized.  However, by Adding these attributes mean you are making your entities service specific which I believe not a good idea. Service and domain specific entities should be seperate. One solution to this would be to make DTOs and decorate them with these attributes and this make sense as core purpose of these DTOs is serialization and deserialization. What can be other options....? Please share your thoughts. Thanks, Naeem

Questions on Multi-Tenant Data Architecture for SQL Server Database and ASP.NET application

My company wants me to make the same asp.net application and sql server database be sharable amongst different clients. Clients will use the database for their own business use, will have their own data, we will have our own data. How can I share the same SQL Server database amongst different clients having same ASP.NET application (but somehow be able to differentiate which client user is logging in) ? Do I need to use ApplicationID and how will I detect at login which one to use ? I know I will need to add another field in all tables to differentiate client's data from ours.  

Best practice: Where to save data from application pages?

Hello, I have a feature scoped at site level which contains some application pages, where I need to save some "settings data" from. I'm thinking I should use some hidden lists in the root of the site collection to save this data. For example one of the application pages registers timer jobs that should then use information entered in the application page. I'm wondering if this is, in your opinion, the right approach? Thanks.

How to pass multi-value parameters to DDS (data driven subscription)?

Using RS2005, how should multivalue parameters be stored in a database field so that a data driven subscription can properly read and use them?  I have so far had no luck using syntax of: 1)  parm1, parm2 2)  parm1,parm2 Do single qutoes need to explicitly wrap the values?  Can you please provide an example and a SQL INSERT statement using parm1 and parm2 to demonstrate what to store in the database field?  Thanks!!

writing xml data to a string instead of a file

Hi   I have a code that generate xml file from a database table and write the data in a xml file that is created by the program itself  // create xml file and xml writer XmlTextWriter xmlwrtr = new XmlTextWriter("c:\\SitemapTEST2.xml", null); I would like to write the xml data as a string and pass it to a datasource connection , how is this possible? something like this  this.ExplorerBarDataSource.Data = @"<?xml version='1.0' encoding='UTF-8'?> <countries> <country name='United States'> <state name='Alabama'> <city name='Montgomery' pubulation='22,000'/> <city name='Birmingham'/> <city name='Tuscaloosa'/> <city name='Huntsville'/> </state> </country> </countries>";     thanks    

How to put Data in multi Taxonomy type fields using Datasheet view

Hi, We have a requirement where data has to be uploaded to a list having a Multi Taxonomy column.Is it possible to do so using datasheet view. Or please suggest if there is any other way. Thanks, Ash

Writing XML data from URL to Object in SSIS Script Task

I have this URL where there is XML data. I have to extract that data from URL and dump it into DW table. I am using SSIS Script Task for that.

This is how the data looks like:
<cname>United Arab Emirates Dirhams</cname>
<cname>Afghanistan Afghanis</cname>
<cname>Albania Leke</cname>

This is the code i'm using to load it into some Object type or something. But i dont know how to do that.

public void Main()
   String URLString = "http://www.xe.com/dfs/datafeed2.cgi?beeline";
   XmlDocument doc = new XmlDocument();
   XmlTextReader reader = new XmlTextReader(URLString);

   XmlNodeList currencynodes = doc.SelectNodes("currency");
   foreach(XmlNode currency in currencynodes)
    XmlNode csymbol = currency.SelectSingleNode("csymbol&quo

Writing image binary data to the Response


Hi there,

I've created 2 web user controls. A = User control that displays an image, and B is the user control that hosts A. I'm trying to stream an array of bytes to A, but it seems like the Response.BinaryWrite method completely overwrites any heirachial controls (I can't see any of B's other controls besides the image).

How do I get A to just display the image from the byte stream? It doesn't come from a database, it's an image I created on the fly.

A's code:

        public void UpdateImage(byte[] imgbytes)
            Response.ContentType = "image/jpg";


Binary Data Not Writing to Database


I have an ASP.NET app that writes binary data to a SQL database.  It worked fine using SQL Express, but does not ever write the data using SQL Server 2008 R2.  SQL Profiler shows the binary data in the UPDATE query, but nothing happens... no errors, no data saved.  Does anyone know what I'm missing?  Other data types work fine.

My data type is VarBinary(MAX)...


Binary Data Not Writing to Database

This may be more of a dev question, but I have an ASP.NET app that saves binary data to a SQL database.  It worked fine to a SQL Express 2008 database, but does not work on a SQL Server 2008 R2 Standard.  SQL Profiler shows the binary data in the UPDATE query, but nothing is ever actually written to the database.  I cannot find any errors either.  I have no problems writing other types of data.  Any ideas?

Measures for Additive vs Non-Additive Data. What is cube design best practice?


I'm looking more for SSAS 2008 best practice design advice, rather than for an answer to a specific question (although I have a specifc set of examples).

First issue:  Creating a non-additive measure group and an additive measure group.  We have some fact data in our current cube that is additive, and some fact data that is non-additive; all stored in the same fact table.  We do not currently have measures implemented that reflect this aggregation distinction.  Question:  Is it considered good practice to segregate additive and non-additive fact data into a) different fact tables and/or b) different measure groups?  My thought is that it would be an acceptable design approach, but am looking for feedback.

Second issue:  Non-additive fact data is only available at a non-leaf grain.  The example here is that we have non-additive fact data which is only available for the 4th or 5th levels of our 6-level geography dimension.  Our solution has been to create a custom geography branch, which now essentially serves as our 'aggregation treatment' for non-additive fact data.  I don't believe it's a good practice to have the geography dimension serve this function because we end up having to create a custom geo member for each non-additive fact data element.  Question:  What is considered best practice

Integrating PPS Multi level filter into SSRS which uses SQL to pull data



I'm trying to integrate PPS filter (which is created using MDX query and its a multi select tree filter) with an SSRS report, for which the background is SQL Query. Can you please guide me to achieve this. I'm not sure how we can link the multi level hierarchy to an SQL query which is been used in the content part of the SSRS report. For example I have a geography hierarchy in a cube and I use an mdx query to create and populate PPS filter. I need to use this filter in an SSRS report for which the query is 'select col name(s) from table'. Also my hierarchy in the cube is not a natural hierarchy.

Any guidance would be really great and thank full.

- Arvind

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