json - Date Serialization in WCF Rest Service -


I am using C # and I have the following LINQ statement 

  var Weekly sessions are included in db.DashboardFigures outlets from dd.s.spot (','). (X => int.Parse (x)) is equal to d.OutletN, where (d.TypeOfinformation == "sales-TW") group D new group new {d.TypeOfinformation, d.Date} Select WeeklySells () = {DT = ((DateTime) Named Group K.Det), SV = (Double) NSE Group Group. (D = & gt; D. Value_1) + (Double) New Group Endress. Sam (D => D. Value7), KPI = 1};

However, the format of the DT is coming 

  "\ / date (1421884800000 + 0000) \ /

I have tried to convert code to 

  dt = ((datetime) as a registered person.Data has been replaced by toastring ("dd.mm.yyyy")

bit tells me that I can not convert a string into a datetime format.

Since this is a new release service, the best option is to leave WCF and RS services WCF Rest Service was a stop-pipe measurement that used to take a lot of legacy stuff. One of them was abandoned to a great extent and slow serializer is used by it.

Although it is possible to change the serializer, it is not trivial. The process is described by Carlos Figueroa and this is definitely not for beginners.

The code you posted from It turns out that Y ou are trying to create a REST service to support a BI dashboard. In this case you should also consider the top of the web API. A REST service is obtained on OData e data entities and allows customers to specify URLs, query parameters such as filters, selections, groups, etc.

This will allow your client to specify in the URL without the need for parameters and columns. The modification in your service code works on the top of the Odatea IQueryable, so the query to be executed at the end is just data Pulls out the customer from the database.

Visitors in Visual Studio, which allow Odita services to be easily exposed to any entity framework model, although Odata is not limited to EF

Can create direct query URLs or they can use a proxy generated by Visual Studio to work with LINQ syntax, or Javascript client libraries.

Finally, you have to worry about making a strange request to customers who will kill the database. You can highlight specific questions only as methods, or apply your own restrictions on IQueryable which will be exposed.

It is irrespective of doing this with paging or different dashboard pages, very cheap WCF.

PS: Excel can also read data from Odata services. Demand for access to the database should stop analysts and financial managers.

A good shock-to-blow tutorial is


Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more