entity framework - Handling Errors with db.Database.SqlQuery -


I encountered a problem today, where I had a query that was unsuccessful. I use the db.Database.SqlQuery & lt; T & gt; () to query other application data, we have a custom view on their data today, the administrator has rebuilt the indexes in the software and removed custom views in this process. Although this is an issue that no one can solve, the issue you can help, they are handling this matter in a great way where there is no look.

For the main application, we are using this data as supplemental data. This means that the server or table can not be reached, it is not important to display the information. The query is running in WebApi follow-up action (I added some comments based on my observations during debugging.): 

  Public work & lt; HttpResponseMessage & gt; GetByAddress (String ID) {Task & lt; HTTPRPS Pormes & gt; reaction; String sql = // my sql statement; & Lt; Object & gt; ParameterList = New List & lt; Object & gt; (); ParameterList.Add (id.ToUpper ()); Object [param] parameter = list.ToArray (); // This is useless because the following line is completely this IEnumerable & lt; CallsForService & gt; Call = new list & lt; CallForce service & gt; (); // If the table does not exist, it does not make any errors, instead it creates a different object with error descriptions. Call = db. database SQLQuery & lt; CallForce service & gt; (SKL, Ultimate); Reaction = function.formersalt & lt; HTTPRPS Pormes & gt; (Request Create Response (HTTTATS code. OK, call)); Return feedback; }

My question is how do I check these errors and at least honestly send the calling application back to an empty list. I can log these errors with ELMAH so that I can fix this by catching this issue.

The query is not executed until the results are executed, so you only count the number of records Anyone can and can generate any error. 

  calls = db.Database.SqlQuery & lt; CallsForService & gt; SQL, Ultimate); Var recCount = calls.Count ();

Any errors raised after the last line / catch will be caught by the block.


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