How to trigger breakpoint in u-sql code behind (usql.cs) file?









up vote
0
down vote

favorite
1













The break point never trigger on submit job even i tried with local
account having all dll on my system.











share|improve this question





















  • the code behind execute and gives output but no break point trigger for inspection.
    – David
    Nov 11 at 17:41










  • Please help....
    – David
    Nov 11 at 20:08










  • Please post the code and script involved. Are you sure the code is even called by the U-sql script?
    – Peter Bons
    Nov 12 at 6:42














up vote
0
down vote

favorite
1













The break point never trigger on submit job even i tried with local
account having all dll on my system.











share|improve this question





















  • the code behind execute and gives output but no break point trigger for inspection.
    – David
    Nov 11 at 17:41










  • Please help....
    – David
    Nov 11 at 20:08










  • Please post the code and script involved. Are you sure the code is even called by the U-sql script?
    – Peter Bons
    Nov 12 at 6:42












up vote
0
down vote

favorite
1









up vote
0
down vote

favorite
1






1






The break point never trigger on submit job even i tried with local
account having all dll on my system.











share|improve this question














The break point never trigger on submit job even i tried with local
account having all dll on my system.








azure azure-storage azure-data-lake u-sql azure-analysis-services






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 11 at 17:40









David

32




32











  • the code behind execute and gives output but no break point trigger for inspection.
    – David
    Nov 11 at 17:41










  • Please help....
    – David
    Nov 11 at 20:08










  • Please post the code and script involved. Are you sure the code is even called by the U-sql script?
    – Peter Bons
    Nov 12 at 6:42
















  • the code behind execute and gives output but no break point trigger for inspection.
    – David
    Nov 11 at 17:41










  • Please help....
    – David
    Nov 11 at 20:08










  • Please post the code and script involved. Are you sure the code is even called by the U-sql script?
    – Peter Bons
    Nov 12 at 6:42















the code behind execute and gives output but no break point trigger for inspection.
– David
Nov 11 at 17:41




the code behind execute and gives output but no break point trigger for inspection.
– David
Nov 11 at 17:41












Please help....
– David
Nov 11 at 20:08




Please help....
– David
Nov 11 at 20:08












Please post the code and script involved. Are you sure the code is even called by the U-sql script?
– Peter Bons
Nov 12 at 6:42




Please post the code and script involved. Are you sure the code is even called by the U-sql script?
– Peter Bons
Nov 12 at 6:42












1 Answer
1






active

oldest

votes

















up vote
0
down vote



accepted










To debug u-sql c# assemblies, you will need to select "Debug" build and start with F5 / Run. If the break point is inside code behind file, it will be handled automatically. If it is in external assemblies, you will need to make sure the correspondent symbol files (*.pdb) can be loaded automatically by VS debugger. You can, for example, either register these symbol files as "WITH ADDITIONAL FILES" during assembly registration, or to follow the guides here: https://docs.microsoft.com/en-us/visualstudio/debugger/specify-symbol-dot-pdb-and-source-files-in-the-visual-studio-debugger?view=vs-2017



You can always check the output log window to see if the correspondent symbols are loaded.



Alternatively, you can add this in the correspondent code to force a break.
https://docs.microsoft.com/en-us/dotnet/api/system.diagnostics.debugger.break?view=netframework-4.7.2






share|improve this answer




















  • Thanks alot. May i know how can I use Newtonsoft.Json in usql.cs file. We cannot add nuget package then how to use Newtonsoft???
    – David
    Nov 13 at 14:52











  • Code behind is not meant to be used for complex assemblies that has external dependencies as these external assemblies will not be registered automatically when you use code behind. In your case, I suggest that you create a separate C# assembly project that implements your function which can refer to nuget packages. However, for the query to work, you will also need to extract the Newtonsoft.Json assembly from the Nuget package (a renamed ZIP file) and then register and reference in your query.
    – Yu Dong Yang
    Nov 14 at 2:38










Your Answer






StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53251434%2fhow-to-trigger-breakpoint-in-u-sql-code-behind-usql-cs-file%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes








up vote
0
down vote



accepted










To debug u-sql c# assemblies, you will need to select "Debug" build and start with F5 / Run. If the break point is inside code behind file, it will be handled automatically. If it is in external assemblies, you will need to make sure the correspondent symbol files (*.pdb) can be loaded automatically by VS debugger. You can, for example, either register these symbol files as "WITH ADDITIONAL FILES" during assembly registration, or to follow the guides here: https://docs.microsoft.com/en-us/visualstudio/debugger/specify-symbol-dot-pdb-and-source-files-in-the-visual-studio-debugger?view=vs-2017



You can always check the output log window to see if the correspondent symbols are loaded.



Alternatively, you can add this in the correspondent code to force a break.
https://docs.microsoft.com/en-us/dotnet/api/system.diagnostics.debugger.break?view=netframework-4.7.2






share|improve this answer




















  • Thanks alot. May i know how can I use Newtonsoft.Json in usql.cs file. We cannot add nuget package then how to use Newtonsoft???
    – David
    Nov 13 at 14:52











  • Code behind is not meant to be used for complex assemblies that has external dependencies as these external assemblies will not be registered automatically when you use code behind. In your case, I suggest that you create a separate C# assembly project that implements your function which can refer to nuget packages. However, for the query to work, you will also need to extract the Newtonsoft.Json assembly from the Nuget package (a renamed ZIP file) and then register and reference in your query.
    – Yu Dong Yang
    Nov 14 at 2:38














up vote
0
down vote



accepted










To debug u-sql c# assemblies, you will need to select "Debug" build and start with F5 / Run. If the break point is inside code behind file, it will be handled automatically. If it is in external assemblies, you will need to make sure the correspondent symbol files (*.pdb) can be loaded automatically by VS debugger. You can, for example, either register these symbol files as "WITH ADDITIONAL FILES" during assembly registration, or to follow the guides here: https://docs.microsoft.com/en-us/visualstudio/debugger/specify-symbol-dot-pdb-and-source-files-in-the-visual-studio-debugger?view=vs-2017



You can always check the output log window to see if the correspondent symbols are loaded.



Alternatively, you can add this in the correspondent code to force a break.
https://docs.microsoft.com/en-us/dotnet/api/system.diagnostics.debugger.break?view=netframework-4.7.2






share|improve this answer




















  • Thanks alot. May i know how can I use Newtonsoft.Json in usql.cs file. We cannot add nuget package then how to use Newtonsoft???
    – David
    Nov 13 at 14:52











  • Code behind is not meant to be used for complex assemblies that has external dependencies as these external assemblies will not be registered automatically when you use code behind. In your case, I suggest that you create a separate C# assembly project that implements your function which can refer to nuget packages. However, for the query to work, you will also need to extract the Newtonsoft.Json assembly from the Nuget package (a renamed ZIP file) and then register and reference in your query.
    – Yu Dong Yang
    Nov 14 at 2:38












up vote
0
down vote



accepted







up vote
0
down vote



accepted






To debug u-sql c# assemblies, you will need to select "Debug" build and start with F5 / Run. If the break point is inside code behind file, it will be handled automatically. If it is in external assemblies, you will need to make sure the correspondent symbol files (*.pdb) can be loaded automatically by VS debugger. You can, for example, either register these symbol files as "WITH ADDITIONAL FILES" during assembly registration, or to follow the guides here: https://docs.microsoft.com/en-us/visualstudio/debugger/specify-symbol-dot-pdb-and-source-files-in-the-visual-studio-debugger?view=vs-2017



You can always check the output log window to see if the correspondent symbols are loaded.



Alternatively, you can add this in the correspondent code to force a break.
https://docs.microsoft.com/en-us/dotnet/api/system.diagnostics.debugger.break?view=netframework-4.7.2






share|improve this answer












To debug u-sql c# assemblies, you will need to select "Debug" build and start with F5 / Run. If the break point is inside code behind file, it will be handled automatically. If it is in external assemblies, you will need to make sure the correspondent symbol files (*.pdb) can be loaded automatically by VS debugger. You can, for example, either register these symbol files as "WITH ADDITIONAL FILES" during assembly registration, or to follow the guides here: https://docs.microsoft.com/en-us/visualstudio/debugger/specify-symbol-dot-pdb-and-source-files-in-the-visual-studio-debugger?view=vs-2017



You can always check the output log window to see if the correspondent symbols are loaded.



Alternatively, you can add this in the correspondent code to force a break.
https://docs.microsoft.com/en-us/dotnet/api/system.diagnostics.debugger.break?view=netframework-4.7.2







share|improve this answer












share|improve this answer



share|improve this answer










answered Nov 13 at 1:53









Yu Dong Yang

23615




23615











  • Thanks alot. May i know how can I use Newtonsoft.Json in usql.cs file. We cannot add nuget package then how to use Newtonsoft???
    – David
    Nov 13 at 14:52











  • Code behind is not meant to be used for complex assemblies that has external dependencies as these external assemblies will not be registered automatically when you use code behind. In your case, I suggest that you create a separate C# assembly project that implements your function which can refer to nuget packages. However, for the query to work, you will also need to extract the Newtonsoft.Json assembly from the Nuget package (a renamed ZIP file) and then register and reference in your query.
    – Yu Dong Yang
    Nov 14 at 2:38
















  • Thanks alot. May i know how can I use Newtonsoft.Json in usql.cs file. We cannot add nuget package then how to use Newtonsoft???
    – David
    Nov 13 at 14:52











  • Code behind is not meant to be used for complex assemblies that has external dependencies as these external assemblies will not be registered automatically when you use code behind. In your case, I suggest that you create a separate C# assembly project that implements your function which can refer to nuget packages. However, for the query to work, you will also need to extract the Newtonsoft.Json assembly from the Nuget package (a renamed ZIP file) and then register and reference in your query.
    – Yu Dong Yang
    Nov 14 at 2:38















Thanks alot. May i know how can I use Newtonsoft.Json in usql.cs file. We cannot add nuget package then how to use Newtonsoft???
– David
Nov 13 at 14:52





Thanks alot. May i know how can I use Newtonsoft.Json in usql.cs file. We cannot add nuget package then how to use Newtonsoft???
– David
Nov 13 at 14:52













Code behind is not meant to be used for complex assemblies that has external dependencies as these external assemblies will not be registered automatically when you use code behind. In your case, I suggest that you create a separate C# assembly project that implements your function which can refer to nuget packages. However, for the query to work, you will also need to extract the Newtonsoft.Json assembly from the Nuget package (a renamed ZIP file) and then register and reference in your query.
– Yu Dong Yang
Nov 14 at 2:38




Code behind is not meant to be used for complex assemblies that has external dependencies as these external assemblies will not be registered automatically when you use code behind. In your case, I suggest that you create a separate C# assembly project that implements your function which can refer to nuget packages. However, for the query to work, you will also need to extract the Newtonsoft.Json assembly from the Nuget package (a renamed ZIP file) and then register and reference in your query.
– Yu Dong Yang
Nov 14 at 2:38

















draft saved

draft discarded
















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.





Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


Please pay close attention to the following guidance:


  • Please be sure to answer the question. Provide details and share your research!

But avoid


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53251434%2fhow-to-trigger-breakpoint-in-u-sql-code-behind-usql-cs-file%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







這個網誌中的熱門文章

How to read a connectionString WITH PROVIDER in .NET Core?

In R, how to develop a multiplot heatmap.2 figure showing key labels successfully

Museum of Modern and Contemporary Art of Trento and Rovereto