I personally haven’t read the  whole book but  from what I have read it has some good foundation truths that I  would like to practice and  it makes easier to describe concepts that I also share with the author.

Build Radically candid relationship

• Relationships not Power  ,drive forward success.
• The ability to build trusting real connections with your direct reports will determine the quality of effort that follows
• Care Personally – shed the arrogance, be humble and follow a servant leader model

Get,give and encourage guidance

Radical Candor Care Personally +  Challenging Directly. This breaks out into 4 quadrants

• Manipulative insincerity  – tells you
• Obnoxious Aggression – the office jerk, tells you your faults but not invested so you don’t trust him.
• Ruinous Empathy – the boss that needs to be liked
• Radical Candor – team leader is invested in the team members , so much that he is accountable as if they were one in the same
• Worry more about praise giving and less about criticism- always be sincere.

Understand what motivates each person on your team

• Rockstars vs Super stars.  Former are rock solid, latter need a path to the next step.
• Growth Management – its necessary to transfer from talent management mindset to a growth management mindset
• Find out what motivates  each team member personally.
• You aren’t responsible for finding purpose in their work ,but rather to create a working environment which allows people to discover it. Invest in your
• Keep your top performers  moving forward
• Gradual Growth Trajectory for rock stars: Find a way to recognize and reward rock stars without necessarily promoting them
• Steep Growth Trajectory: don’t make management the only path to  higher compensation, less the quality of management will suffer and the lives of those who work under them will also suffer.
• Identity those that are stuck in the road. Finding a path back to their amazing may take a step or 2 back.
• When to Fire? Have you given radically candid guidance? how is this person’s performance affecting the rest of the team? Have you sought a second opinion , spoekn to someone you trust about the problem? If its time, make sure not to distance yourself from the person you will be firing.

Drive Results Collaboratively

Telling people what to do doesn’t work
The Art of getting stuff done is  without implicitly telling people what to do.

• Listen  – create an environment where you and others will listen
• Clarify -have you and direct reports understand and convey thoughts and ideas more clearly.
  • Become  an editor not an author. Not just in understanding problems & solutions but understanding the people whom we will have to explain the ideas to.
• Debate : Debate is necessary to get everyone on the same page and lack of consensus will cause mass dissension.
  • keep conversations focus on ideas
  • create an obligation to dissent  (related)
  • Pause for emotion\exhaustion;
  • pick a decision when the debate is over; don’t pick it because the debate got difficult
• Decide: good bosses create a decision-making process that empowers the most knowledgeable people to make as many decisions as possible
• Persuade : it is necessary to not only inform but persuade those  invested in your decision that it is the best decision. Find who will have the biggest credibility  in the decision process
  • consider credibility , humility , by showing your work  (share how you came to the idea\decision)  and consider the room ( the people’s emotion)
• Execute:  empower the team by dealing with the colab. tax with other groups .
• Learn: don’t deny failures, learn from them them and improve. be careful with the need to consistent and watch out for signs of burnout.

Part 2 : tools & Techniques

Relationships: An approach to establishing trust with your direct reports

• Centered and Balanced life : ensure you have a stable life so that you can bring that to work.
• Extend to your team: create the opportunity so they can bring their best selves to work.
• Respect individual boundaries:  be open, and allow them to open up. Each person is an individual and it will be your responsibility to balance between respecting their boundaries and allowing them to be all they are at work.

Guidance

• get,give and encourage both praise and criticism
• Make sure you are giving them the opportunity to give real  feedback about your self, ask for it.
  • Some ideas to move it forward:    allow yourself to be publicly criticized initially,  listen with the intent of understanding not action. Reward criticism to get more of it.
• Give others guidance
• Gauge your guidance, create a baseline and track improvements
• Radically candid with your boss:  proceed with caution , first allowing them to be candid. A strong leader has the humility to listen, the confidence to challenge, and the wisdom to know when to quit arguing and get on board.
• Prevent backstabbing by ensuring communication first happens with the person you having the issue with first.
• Peer guidance : encourage your group to gauge their guidance and ensure we are all using the same vocabulary
• Skip meetings can be useful to getting feedback directly. (Skip meetings skip 1 level of managers and directly talks to the groups)

Well I enjoyed this book quite a bit.

• Chapter Opening:
  • Provides a couple examples of older applications who’s model while  present, were not usable to really understand nor  continue the work on. as a result the model was scrapped or replaced.
• Model-Driven Design
  • the astrolabe is used as an example of a mechanical implementation of an object oriented model.
  • Analysis on implementation is necessary to avoid  double analysis; and having the management understand that secondary analysis is as important if not even more relevant  then the initial analysis
  • the model-driven design  should be a single model that servers both the business and the technical needs in one domain. Agnostic but relevant to both.
    • its a model that works both as analysis and design at the same time
    • It should be iteratively reviewed,  improved and fixed
• Modeling Paradigms and Tool Support
  • It is important to have  tooling that supports model concepts; a language like C# that is OO is a good fit.
  • Example of PCB  where  the concept of a network bus didn’t exist but had to be implemented as a side item and as a result  didn’t have the same
• Letting the Bones Show: Why Models Matter to Users
  • there is a  divide between  the analysis /design implementation and the user design, however there should only be one model guiding all of these.
    • Example of IE Favorites: why hide away that they are just files and force usage of the files through IE’s old interface. be clear or  redesign the model to truly show what is behind.
• Hands-On Modelers
  • management feels that architects shouldn’t model and its a waste of time. Problems will arise because the model will be left behind and feedback loop from the tech team back to the architect will be reduced significantly
  • the people that write the code must feel responsible for the model and if they don’t understand it , the model is ignored or sidestepped.
  • Modeling and implementation of the model, must go hand in hand.
  • Technical contributes to the model must spend time coding, any developers must learn to express the model in code.  Stakeholders must engage the model through Ubiquitous Language.

You can get the  reference document here:
https://domainlanguage.com/ddd/reference/

The original book is still available for purchase
https://www.amazon.com/Domain-Driven-Design-Tackling-Complexity-Software/dp/0321125215

Chapter 1

• Ingredients of Effective Modeling
  • Sharing a common Language
  • Developing a knowledge-rich model
    • the model was used both for solving problems but also for understanding any limitations til current
  • Reductive Model: as  the model became clearer the scope of the model could also be decreased
  • Experimentation Lab: The model was used as a testing ground and lab for futher and future review
• Knowledge Crunching
  • old style is to tell the developer what to build and they can built it. Maybe even keep it clean but it will not grow past  that and it can’t add on new powerful  collaborative features.
  • The process has to be collective and iterative and conjoined ; Dev & business.
• Continuous Learning
  • Technical Knowledge, general domain-modeling skills and domain specific knowledge
• Knowledge-Rich  Design
  • it is imperative not only to find the nouns and verbs, but have a natural way to express the entire model

Chapter 2

• Ubiquitous Language
  • It is necessary to share in one language to describe and describe the domain
  • use the mode as the backbone of language
• Modeling Out Loud
  • Be intentful in describing and using the model in day to day speech to test it out and make it functional
• One Team, One Language
  • Don’t take no for an answer. there must be  common ground to speak on what is being built.
• Documents and Diagrams
  • The vital detail about the design is captured in the code
  • persistent form documents lose their connection from the flow of a project, and are left behind because of the evolution of code and the evolution of the language of the project
  • Diagrams are not the model
  • Documents should complement code and speech
• Explanatory Models

http://robertgreiner.com/2013/09/software-developer-book-recommendations/

I am starting with clean Code Chapter 1.

The Qualities of Clean Code

• Bjarne Stroustrup
  • Elegant
  • Efficient
  • error handling complete
  • performance close to optimal
    • as to avoid temptation to make the code messy
  • does one thing well
• Grady Booch
  • is crisp, isn’t obscure
    • reads well
• Dave Thomas  (OTI)
  • Testable
  • Easy to maintain
• Michael Feathers
  • the code looks like it was built by someone that cares about the code
• Ron Jefferies
  • Runs all the tets
  • contains no dups
  • minimizes the # of entities
  • expressiveness – tiny abstractions
• Boy Scouts rule: Leave Campground better than it was. Apply to code.

Need to re-asset want to focus on and need to learn new techniques to help me through this journey. So I am going to watch a few time management and  effectiveness videos. Here are summaries

1. Time
   1. Track
      1. Track what you are doing , so you can understand what you are spending your time
   2. Manage
      1. 1/2 days to 2 weeks of quantum of time
   3. Consolidate
2. Contribute
   1. Who do you need to be to contribute
3. Strength
   1. All strong people have peaks and valleys
   2. People that well rounded ,are going to end up in mediocrity
   3. Only exception is character and integrity you need to resolve that
   4. Example:  Ulysses Grant  and Lincoln,  Grant could fight , Grant would drink
4. Concentration
   1. There will always be more good ideas than there is time to execute them
   2. Stephen Covey – First things first , Second things ” not at all”
5. Decisions
   1. they make effective decisions, they make less decisions . But they make big decisions not a ton of little decisions
   2. We need to have boundary conditions
      1. what is your routine?

Reinventing Yourself

https://play.google.com/store/books/details?id=T95EDwAAQBAJ&source=productsearch&utm_source=HA_Desktop_US&utm_medium=SEM&utm_campaign=PLA&pcampaignid=MKTAD0930BO1&gclid=Cj0KCQjwjvXeBRDDARIsAC38TP4OuTcvvUY4C00cACnkpjqIMQVhWeEQOwZEpwaSoBIacjqlC8M6JucaAtsYEALw_wcB&gclsrc=aw.ds

1. Victim vs Owner
   1. Do you own your destiny
2. Styrofoam Weights
   1. Avoiding Challenges & Problems
   2. Metaphor “Styrofoam” weight
   3. Owners look at weights in a gym
   4. they are spiraling up, evolving with errors and failures
3. Yes + No
   1.  In order to get a yes, you have to get a lot of nos
   2. Success goes with Failures
   3. Yes’es goes with no
   4. we need embrace failure
4. 10 things
   1. Courage comes in the act of doing something
   2. You can’t wait until you are doing something
   3. 10 things  that you would do if you had no fear
   4. Because we do not dare, we do not do things that are difficult
   5. fear can be like salt in a river, take the jump and feel the exciment and the fear at the same time
5. Campfire of Life
   1. you need to make a new campfire every day
   2. on the material plane, you build a chair and its there but on a spiritual plane you will need to remake it every day

What is the best version of you look like?

I am going to spend some time answering that today.

Was about to go the yml route when I decided to try the  format;

az container create   -e 'key:"value"'

and that worked like a charm.
this is useful when  you have problematic characters (& , ! ,etc.)

Example:

az container create -g myGroup -n MyContainer--image MyImage 
-e 'YOUR_KEY_URL="jdbc:mysql://databaselocation:3306/sonarqube?useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true&useConfigs=maxPerformance&autoReconnect=true&useSSL=false"'

Results in Azure:

I tried other methods (escaping characters, single quotes, double quotes, ^ sign, double ampersand, and even double quote followed by single) but only this format worked.

I believe this solves this person’s error:
https://github.com/Azure/azure-cli/issues/5573
I will also try to cross post it to:
https://docs.microsoft.com/en-us/azure/container-instances/container-instances-environment-variables

Going to be following this :
https://blogs.msdn.microsoft.com/webdev/2018/05/30/asp-net-core-2-1-0-now-available/
and a recently written document for project migration :
https://docs.microsoft.com/en-us/aspnet/core/migration/20_21?view=aspnetcore-2.1

Steps are:

1. Download  ASP.net Core 2.1 SDK 
2.  replace <TargetFramework>netcoreapp2.0</TargetFramework> to <TargetFramework>netcoreapp2.1</TargetFramework>
3. remove references to DotNetCliToolReference in certain Packages
4. Bonus Round: Getting VSTS to build .net Core  2.1

Install ASP.net Core 2.1 SDK

Downloaded a file  named dotnet-sdk-2.1.302-win-gs-x64.exe   when I clicked on  the “Download .NET SDK ” with a size of about 135 MB, run the file and accepted the run.

Completed,  and that seemed easy enough.

Replace TargetFramework value with netcoreapp2.1

So I used Notepad’++’s  Find in Files, I tend to use this for smaller  text replacements.

That seemed to find everything I needed to replace:

so I ran it a second time this time making the necessary text replacement. I hand checked a few, and it all looked good.

Ok , so step 1 in theory done.

Now I went back to my Project and opened up one of my projects that  other than referencing Core 2.0 had no code ,nuget packages  or dependencies. I built it and it was successful now that it was pointing to Core 2.1.  So that’s progress.

Replace  AspNetCore.All with AspNetCore.App

So my first step as  a test is to remove the reference from one   project with AspNetCore.All to see how bad it is . I picked 1 project called  WebApi ,and removed the reference. I didn’t see any other references drop, ok so  far so good.

Now keep in mind at this point  Nuget Package manager is telling me this project has no packages installed because it can’t build because of it pointing to  netcoreapp2.1 which doesn’t exist as a valid reference.

Now the blow for me was the License Acceptance,  when I went to install  Microsoft.AspNetCore.App it wanted me to accept at  my estimate (got scroll bar  1/4 down with 65  packages counted) about 200+ licenses.

Also I can’t copy and paste the license acceptance. With that much to go through it makes it almost impossible for a developer to be  able to review this. Sure we have tooling to  review dependencies issues   and vulnerabilities but who are we even kidding at this point with these type of acceptances?

I hit “I Accept” but honestly its the first time I had signed up for 200 plus agreements in one click; feel free to take a look at what was installed.

Restoring packages for D:\Repository\CSharpRomp\CSharpRomp.WebApi\CSharpRomp.WebApi.csproj...
Installing NuGet package Microsoft.AspNetCore.App 2.1.2.
Committing restore...
Generating MSBuild file D:\Repository\CSharpRomp\CSharpRomp.WebApi\obj\CSharpRomp.WebApi.csproj.nuget.g.props.
Generating MSBuild file D:\Repository\CSharpRomp\CSharpRomp.WebApi\obj\CSharpRomp.WebApi.csproj.nuget.g.targets.
Writing lock file to disk. Path: D:\Repository\CSharpRomp\CSharpRomp.WebApi\obj\project.assets.json
Restore completed in 2.36 sec for D:\Repository\CSharpRomp\CSharpRomp.WebApi\CSharpRomp.WebApi.csproj.
Successfully uninstalled 'Microsoft.Win32.Registry 4.4.0' from CSharpRomp.WebApi
Successfully uninstalled 'System.Data.SqlClient 4.4.3' from CSharpRomp.WebApi
Successfully uninstalled 'System.Security.AccessControl 4.4.0' from CSharpRomp.WebApi
Successfully uninstalled 'System.Security.Principal.Windows 4.4.0' from CSharpRomp.WebApi
Successfully uninstalled 'System.Text.Encoding.CodePages 4.4.0' from CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNet.WebApi.Client 5.2.6' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore 2.1.2' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Antiforgery 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.App 2.1.2' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Authentication 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Authentication.Abstractions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Authentication.Cookies 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Authentication.Core 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Authentication.Facebook 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Authentication.Google 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Authentication.JwtBearer 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Authentication.MicrosoftAccount 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Authentication.OAuth 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Authentication.OpenIdConnect 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Authentication.Twitter 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Authentication.WsFederation 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Authorization 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Authorization.Policy 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Connections.Abstractions 2.1.2' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.CookiePolicy 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Cors 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Cryptography.Internal 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Cryptography.KeyDerivation 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.DataProtection 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.DataProtection.Abstractions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.DataProtection.Extensions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Diagnostics 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Diagnostics.Abstractions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Diagnostics.EntityFrameworkCore 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.HostFiltering 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Hosting 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Hosting.Abstractions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Hosting.Server.Abstractions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Html.Abstractions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Http 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Http.Abstractions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Http.Connections 1.0.2' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Http.Connections.Common 1.0.2' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Http.Extensions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Http.Features 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.HttpOverrides 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.HttpsPolicy 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Identity 2.1.2' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Identity.EntityFrameworkCore 2.1.2' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Identity.UI 2.1.2' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.JsonPatch 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Localization 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Localization.Routing 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.MiddlewareAnalysis 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Mvc 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Mvc.Abstractions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Mvc.Analyzers 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Mvc.ApiExplorer 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Mvc.Core 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Mvc.Cors 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Mvc.DataAnnotations 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Mvc.Formatters.Json 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Mvc.Formatters.Xml 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Mvc.Localization 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Mvc.Razor 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Mvc.Razor.Extensions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Mvc.Razor.ViewCompilation 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Mvc.RazorPages 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Mvc.TagHelpers 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Mvc.ViewFeatures 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.NodeServices 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Owin 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Razor 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Razor.Design 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Razor.Language 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Razor.Runtime 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.ResponseCaching 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.ResponseCaching.Abstractions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.ResponseCompression 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Rewrite 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Routing 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Routing.Abstractions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Server.HttpSys 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Server.IISIntegration 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Server.Kestrel 2.1.2' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Server.Kestrel.Core 2.1.2' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Server.Kestrel.Https 2.1.2' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Server.Kestrel.Transport.Abstractions 2.1.2' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Server.Kestrel.Transport.Sockets 2.1.2' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.Session 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.SignalR 1.0.2' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.SignalR.Common 1.0.2' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.SignalR.Core 1.0.2' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.SignalR.Protocols.Json 1.0.2' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.SpaServices 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.SpaServices.Extensions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.StaticFiles 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.WebSockets 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.AspNetCore.WebUtilities 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.CodeAnalysis.Analyzers 1.1.0' to CSharpRomp.WebApi
Successfully installed 'Microsoft.CodeAnalysis.Common 2.8.0' to CSharpRomp.WebApi
Successfully installed 'Microsoft.CodeAnalysis.CSharp 2.8.0' to CSharpRomp.WebApi
Successfully installed 'Microsoft.CodeAnalysis.Razor 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.CSharp 4.5.0' to CSharpRomp.WebApi
Successfully installed 'Microsoft.DotNet.PlatformAbstractions 2.1.0' to CSharpRomp.WebApi
Successfully installed 'Microsoft.EntityFrameworkCore 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.EntityFrameworkCore.Abstractions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.EntityFrameworkCore.Analyzers 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.EntityFrameworkCore.Design 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.EntityFrameworkCore.InMemory 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.EntityFrameworkCore.Relational 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.EntityFrameworkCore.SqlServer 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.EntityFrameworkCore.Tools 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Caching.Abstractions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Caching.Memory 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Caching.SqlServer 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Configuration 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Configuration.Abstractions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Configuration.Binder 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Configuration.CommandLine 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Configuration.EnvironmentVariables 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Configuration.FileExtensions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Configuration.Ini 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Configuration.Json 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Configuration.KeyPerFile 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Configuration.UserSecrets 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Configuration.Xml 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.DependencyInjection 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.DependencyInjection.Abstractions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.DependencyModel 2.1.0' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.DiagnosticAdapter 2.1.0' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.FileProviders.Abstractions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.FileProviders.Composite 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.FileProviders.Embedded 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.FileProviders.Physical 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.FileSystemGlobbing 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Hosting 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Hosting.Abstractions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Http 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Identity.Core 2.1.2' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Identity.Stores 2.1.2' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Localization 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Localization.Abstractions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Logging 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Logging.Abstractions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Logging.Configuration 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Logging.Console 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Logging.Debug 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Logging.EventSource 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Logging.TraceSource 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.ObjectPool 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Options 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Options.ConfigurationExtensions 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.Primitives 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Extensions.WebEncoders 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.IdentityModel.Logging 5.2.0' to CSharpRomp.WebApi
Successfully installed 'Microsoft.IdentityModel.Protocols 5.2.0' to CSharpRomp.WebApi
Successfully installed 'Microsoft.IdentityModel.Protocols.OpenIdConnect 5.2.0' to CSharpRomp.WebApi
Successfully installed 'Microsoft.IdentityModel.Protocols.WsFederation 5.2.0' to CSharpRomp.WebApi
Successfully installed 'Microsoft.IdentityModel.Tokens 5.2.0' to CSharpRomp.WebApi
Successfully installed 'Microsoft.IdentityModel.Tokens.Saml 5.2.0' to CSharpRomp.WebApi
Successfully installed 'Microsoft.IdentityModel.Xml 5.2.0' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Net.Http.Headers 2.1.1' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Win32.Primitives 4.3.0' to CSharpRomp.WebApi
Successfully installed 'Microsoft.Win32.Registry 4.5.0' to CSharpRomp.WebApi
Successfully installed 'NETStandard.Library 1.6.1' to CSharpRomp.WebApi
Successfully installed 'Newtonsoft.Json 11.0.2' to CSharpRomp.WebApi
Successfully installed 'Newtonsoft.Json.Bson 1.0.1' to CSharpRomp.WebApi
Successfully installed 'Remotion.Linq 2.2.0' to CSharpRomp.WebApi
Successfully installed 'runtime.debian.8-x64.runtime.native.System.Security.Cryptography.OpenSsl 4.3.0' to CSharpRomp.WebApi
Successfully installed 'runtime.fedora.23-x64.runtime.native.System.Security.Cryptography.OpenSsl 4.3.0' to CSharpRomp.WebApi
Successfully installed 'runtime.fedora.24-x64.runtime.native.System.Security.Cryptography.OpenSsl 4.3.0' to CSharpRomp.WebApi
Successfully installed 'runtime.native.System 4.3.0' to CSharpRomp.WebApi
Successfully installed 'runtime.native.System.IO.Compression 4.3.0' to CSharpRomp.WebApi
Successfully installed 'runtime.native.System.Net.Http 4.3.0' to CSharpRomp.WebApi
Successfully installed 'runtime.native.System.Security.Cryptography.Apple 4.3.0' to CSharpRomp.WebApi
Successfully installed 'runtime.native.System.Security.Cryptography.OpenSsl 4.3.0' to CSharpRomp.WebApi
Successfully installed 'runtime.opensuse.13.2-x64.runtime.native.System.Security.Cryptography.OpenSsl 4.3.0' to CSharpRomp.WebApi
Successfully installed 'runtime.opensuse.42.1-x64.runtime.native.System.Security.Cryptography.OpenSsl 4.3.0' to CSharpRomp.WebApi
Successfully installed 'runtime.osx.10.10-x64.runtime.native.System.Security.Cryptography.Apple 4.3.0' to CSharpRomp.WebApi
Successfully installed 'runtime.osx.10.10-x64.runtime.native.System.Security.Cryptography.OpenSsl 4.3.0' to CSharpRomp.WebApi
Successfully installed 'runtime.rhel.7-x64.runtime.native.System.Security.Cryptography.OpenSsl 4.3.0' to CSharpRomp.WebApi
Successfully installed 'runtime.ubuntu.14.04-x64.runtime.native.System.Security.Cryptography.OpenSsl 4.3.0' to CSharpRomp.WebApi
Successfully installed 'runtime.ubuntu.16.04-x64.runtime.native.System.Security.Cryptography.OpenSsl 4.3.0' to CSharpRomp.WebApi
Successfully installed 'runtime.ubuntu.16.10-x64.runtime.native.System.Security.Cryptography.OpenSsl 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.AppContext 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Buffers 4.5.0' to CSharpRomp.WebApi
Successfully installed 'System.Collections 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Collections.Concurrent 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Collections.Immutable 1.5.0' to CSharpRomp.WebApi
Successfully installed 'System.Collections.NonGeneric 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Collections.Specialized 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.ComponentModel.Annotations 4.5.0' to CSharpRomp.WebApi
Successfully installed 'System.Console 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Data.SqlClient 4.5.1' to CSharpRomp.WebApi
Successfully installed 'System.Diagnostics.Contracts 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Diagnostics.Debug 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Diagnostics.DiagnosticSource 4.5.0' to CSharpRomp.WebApi
Successfully installed 'System.Diagnostics.FileVersionInfo 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Diagnostics.StackTrace 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Diagnostics.Tools 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Diagnostics.Tracing 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Dynamic.Runtime 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Globalization 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Globalization.Calendars 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Globalization.Extensions 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.IdentityModel.Tokens.Jwt 5.2.0' to CSharpRomp.WebApi
Successfully installed 'System.Interactive.Async 3.1.1' to CSharpRomp.WebApi
Successfully installed 'System.IO.Compression 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.IO.Compression.ZipFile 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.IO.FileSystem 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.IO.FileSystem.Primitives 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.IO.Pipelines 4.5.0' to CSharpRomp.WebApi
Successfully installed 'System.Linq 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Linq.Expressions 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Linq.Queryable 4.0.1' to CSharpRomp.WebApi
Successfully installed 'System.Memory 4.5.1' to CSharpRomp.WebApi
Successfully installed 'System.Net.Http 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Net.Primitives 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Net.Sockets 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Net.WebSockets.WebSocketProtocol 4.5.1' to CSharpRomp.WebApi
Successfully installed 'System.Numerics.Vectors 4.5.0' to CSharpRomp.WebApi
Successfully installed 'System.ObjectModel 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Private.DataContractSerialization 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Reflection.Emit 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Reflection.Extensions 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Reflection.Metadata 1.6.0' to CSharpRomp.WebApi
Successfully installed 'System.Resources.ResourceManager 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Runtime.CompilerServices.Unsafe 4.5.1' to CSharpRomp.WebApi
Successfully installed 'System.Runtime.Extensions 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Runtime.Handles 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Runtime.InteropServices 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Runtime.InteropServices.RuntimeInformation 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Runtime.Numerics 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Runtime.Serialization.Primitives 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Runtime.Serialization.Xml 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Security.AccessControl 4.5.0' to CSharpRomp.WebApi
Successfully installed 'System.Security.Claims 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Security.Cryptography.Algorithms 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Security.Cryptography.Cng 4.5.0' to CSharpRomp.WebApi
Successfully installed 'System.Security.Cryptography.Csp 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Security.Cryptography.Encoding 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Security.Cryptography.OpenSsl 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Security.Cryptography.Pkcs 4.5.0' to CSharpRomp.WebApi
Successfully installed 'System.Security.Cryptography.Primitives 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Security.Cryptography.X509Certificates 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Security.Cryptography.Xml 4.5.0' to CSharpRomp.WebApi
Successfully installed 'System.Security.Permissions 4.5.0' to CSharpRomp.WebApi
Successfully installed 'System.Security.Principal 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Security.Principal.Windows 4.5.0' to CSharpRomp.WebApi
Successfully installed 'System.Text.Encoding.CodePages 4.5.0' to CSharpRomp.WebApi
Successfully installed 'System.Text.Encoding.Extensions 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Text.Encodings.Web 4.5.0' to CSharpRomp.WebApi
Successfully installed 'System.Text.RegularExpressions 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Threading 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Threading.Channels 4.5.0' to CSharpRomp.WebApi
Successfully installed 'System.Threading.Tasks.Extensions 4.5.1' to CSharpRomp.WebApi
Successfully installed 'System.Threading.Tasks.Parallel 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Threading.Thread 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Threading.Timer 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.ValueTuple 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Xml.ReaderWriter 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Xml.XDocument 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Xml.XmlDocument 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Xml.XmlSerializer 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Xml.XPath 4.3.0' to CSharpRomp.WebApi
Successfully installed 'System.Xml.XPath.XDocument 4.3.0' to CSharpRomp.WebApi
Executing script file 'C:\Users\daxmax\.nuget\packages\microsoft.entityframeworkcore.tools\2.1.1\tools\init.ps1'...
Executing nuget actions took 3.09 sec
Time Elapsed: 00:00:05.7809010
========== Finished ==========

Now   keep in mind I have 2 projects that have dependency on AspNetCore.All . So I attempt to rebuild WebApi  and success. Mileage may vary as the document does describe that removing AspNetCore.All will remove any dependent nuget packages ,  but for my little test project that seemed fine. Moving on to  doing the same in the Web UI project.

I got an odd error when trying to install AspNetCore.App , “Version conflict detected for Microsoft.CodeAnalysis.Common”, did a couple searches and landed on this which suggested some package updates, which  I did do and it seemed to clear up this error for me.

Remove references to  DotNetCliToolReference

So I checked for the packages in the list, and I wasn’t using any of them and that made this step easy. For a 100% assurance I did a scan for that value

• Microsoft.DotNet.Watcher.Tools
• Microsoft.EntityFrameworkCore.Tools.DotNet
• Microsoft.Extensions.Caching.SqlConfig.Tools
• Microsoft.Extensions.SecretManager.Tools

Now there was an optional step to remove DotNetCliTooLReference for CodeGeneration.Tools and that one I did have. Article mentions that can be removed using a  command dotnet tool install -g dotnet-aspnet-codegenerator.

I ran it a second time because it ran too fast but sure enough it was already installed. So my project CSharpRomp is upgraded.

Unfortunately , I had  various other items not committed when I started this so the git commit is a mix of various changes, but you are welcome to dissect those changes here.

https://github.com/EstebanSmits/CSharpRomp/commit/dace0e8d9579b1d0eaf5e614a3d3b32bd4ba1136

Bonus Round: VSTS Build

So if you were following you know we just  installed the 2.1.3 SDK locally but   VSTS doesn’t know about that. So you will need to include a handy dandy .NET Core Tool Installer which is a task type on build.  This tool will allow  installing the SDK package. Adam Storr  details most of this here:
https://adamstorr.azurewebsites.net/blog/aspnetcore-2-1-preview-on-vsts

If you need release versions:
https://github.com/dotnet/core/blob/master/release-notes/releases.csv

Azure Logic Apps is a server-less technology. For those not following along , server less means you don’t worry about the server, Azure will scale it based on your consumption needs. Yay.  Logic Apps also have a ton of pre-built  connectors.

Functionality Breakout

Azure Logic apps can be broken out into 4 main types of events.

• Triggers :  Can be scheduled,  web hook, or driven by other functions
• Actions:  These are internal logic events to perform. Logic checks, statements, business Logic, etc. would be in actions.
• Connectors (MS managed) : these are all the services that Logic Apps connect to. This is probably 80% of what drives the value of using Azure Logic Apps because it makes connecting into various services, very easy. You cannot add your own although there are some basic web hook events you can connect into.
• Flow Control: what to execute next, conditionals, if-else-then, switch and parallel routes

Building A Logic App

Ok, so I am going to build a logic app that is web triggered. We will pass through a Customer Id , and based on whether the customer has a certain volume of orders we will  also notify a chatroom in a slack chat, otherwise I will just reply back with the findings.

1. Receive a  http request
2. Verify if  Customer has  a certain number of orders
3. If # of orders constitutes that he is a big spender, notify slack chat room
4. Send back general response to service request

Preparation

I need:

1. SQL Server Database Server and a database with customer information
2. Slack Channel\user
3.  Something to post the http Request (Postman installed: check)
4. Customers that have big orders
5. Customers that don’t have big orders
6. Stored Procedure  to retrieve Customer Order Details

Going to be using the AdventureWorksLT database for this one, you can do this in Azure as well ( link).

I created a simple stored proc that retrieves some basic Customer Info ( Id, First,Last, OrderID,  Product Name, Order Quantity, and Line  Amount  ) based on customer ID:

-- =============================================
-- Author:    Esteban Smits
-- =============================================
CREATE PROCEDURE SalesLT.RetrieveSaleDetails
(
    -- Add the parameters for the stored procedure here
    @CustomerID int
)
AS
BEGIN
Select C.CustomerID, C.FirstName, C.LastName, SOH.SalesOrderID, 
P.Name,
SOD.OrderQty, SOD.LineTotal from SalesLT.Customer C
join SalesLT.SalesOrderHeader SOH on SOH.CustomerId =C.CustomerID
join SalesLT.SalesOrderDetail SOD on SOD.SalesOrderId  =  SOH.SalesOrderId
join SalesLT.Product P on P.ProductID = SOD.ProductID
where C.CustomerId  = @CustomerID
End        
GO

I also queried the database to find Customers with low and high quantity  orders.

If(OBJECT_ID('tempdb..#tempDB') Is Not Null)
Begin
    Drop Table #tempDB
End 
 Select C.CustomerID, Sum(SOD.OrderQty) as 'NumOrders' into #tempDB  from SalesLT.Customer C
join SalesLT.SalesOrderHeader SOH on SOH.CustomerId =C.CustomerID
join SalesLT.SalesOrderDetail SOD on SOD.SalesOrderId  =  SOH.SalesOrderId
group by C.CUstomerID 
Select * from (Select top 2 * from #tempDB   order by NumOrders DESC) as a1
union
Select * from (Select top 2 * from #tempDB   order by NumOrders ASC) as a2

Excellent, results:

Onto  setting up the Logic App.

Setting up a Logic App

Go to the Azure Portal and Type in Logic App.
Give it a name, select your subscription, create or  use an existing Resource and Res. location.

Please note you can add Log Location but only if you have created an OMS Log Storage . I created one in a directory but even though it was shared between my 2 directories I wasn’t able to select it from the dropdown. Wasn’t the scope so I am going to leave that one for now.

After hitting “Create” ,azure requires time  to deploy the Application (takes 30 seconds).

Refresh the Logic Apps window and a new resource will appear in the list. Click into it. A screen is visualized which reminds me of a Microsoft Workflow, IFTTT, Zapier: (i.e. automation  tooling).

For the purposes of my example  scenario above, I clicked on  “When an HTTP Request is received” as my initial starter action. Please note you can change this later so its a good idea to start with the easiest trigger for your first app. Now the very first thing I wondered was “wait.. all the other azure services make having some access token the first step , where is that security in  Logic Apps?”

How do logic apps secure access?

By default  every  Logic App includes a shared access Signature which is built into the URL. the signature is made up of 3 parts,  version id (sv), signature (sig) and permission type (sp).
You can learn mor about logic app and securing them  here:
Secure access to your logic apps

Building the App

First step is to have the starting event “When a HTTP request is recieved” , I made that a post event. Make sure you do the same unless you want a get event (which is fine by me).I used the data I was going to send  as the model:
{ “customerid”:29796, “name”: “Jack Moneybags”}

it created this, schema model which was fine. I have heard that sometimes it won’t set the correct type for integers so be sure to check as mileage may vary.

{
    "type": "object",
    "properties": {
        "customerid": {
            "type": "integer"
        },
        "name": {
            "type": "string"
        }
    }
}

Once you  save, it will create the  HTTP Request  URL but not until you save, so keep that in mind.

I decided  on the logic for the order counter to be based on number of  orders that had units purchased  greater than 3 , So I needed a  counter  and I wanted a Boolean . I initialized 2 variables (Click “add an Action” and search for initialize variable) , OrderCounter  (integer)and BigOrder (boolean).

I then needed to get data from SQL server, it was as stored  procedure  so I clicked on “Add an Action” and did a search for Stored procedure.

Once added it needs to be able to connect to SQL server , you will need to provide connection string  details plus  a valid credential for that database\stored proc.

Once that was setup, it provided a list of possible Stored Procedures that I  had  and based on the selected stored Procedure, it would populate a list of parameters under it , which could be populated.

I assigned the initial data received in the request as the parameter in for customerid .

Ok great. now I had data but i had to iterate through it. so I need a loop or something.  A quick search returns that a “for each Action” would be the right approach. Added that as an action and used the result set table (it was a dynamic value you could pass through) to iterate through that.

Now that a had an iterator, I added a condition inside of it to check the OrderQty of the results ( it had it available) and checked to see if the value was greater than 3. if it was increment the NumberOfOrders, using an action called “Increment Variable”. Which is important because I tried using assign variable of variable +1 and that didn’t work, so I use increment variable.

Next we need to evaluate if the customer has enough orders to be considered a “Big Order” customer. For that I need an “If Condition”,  a “set variable action”, and additionally a new event of  “Slack Post Message Action”, because if the  customer is a big Order Customer than we want to send a slack message.

The Slack connector will need you to login  for authentication and you  need to have enough administrative grants in Slack to grant authorization .

Finally we need to return the general results, the HTTP output response action.

I created a final action event of response and typed in a basic body JSON message, using the dynamic content menu on the right to plugin  my variables for the response.

Results

John Bodega Customer id 29844  has no high volume orders, so his total count is a big fat goose egg.

with no slack message.

Jack MoneyBags  customer id 29796, has 30 high volume 0rders.

Yay, slack notification!

Bonus Round : Alert Log

My app didn’t work at the beginning so as I was looking into logging ( which Azure Logic Apps don’t have a great deal of debugging functionality just FYI) and  I noticed that Azure just recently released a new version of their alert logger.

Setup is pretty self explanatory ( and pictured below),  but the results were nice.

Notifications (text & email):

]]> https://daxmax.com/azure-logic-apps-webhook-driven-customer-identifier-using-sqlslack/feed/ 0 https://daxmax.com/azure-durable-functions/?utm_source=rss&utm_medium=rss&utm_campaign=azure-durable-functions https://daxmax.com/azure-durable-functions/#respond Fri, 13 Jul 2018 18:58:23 +0000 http://daxmax.com/?p=181 Read more "Azure Durable Functions"

using Microsoft.Azure.WebJobs;
using Microsoft.Azure.WebJobs.Host;
using System.Threading.Tasks;

namespace DurableFunctions
{
    public static class ProcessVideoOrchestrator
    {
        [FunctionName("O_ProcessVideo")]
        public static async Task<object> ProcessVideo(
            [OrchestrationTrigger] DurableOrchestrationContext context, /* tells azure runtime that this is an orchestrator function */
            TraceWriter log 
            )
        {
            var videoLocation = context.GetInput<string>();
            if (!context.IsReplaying) { 
                log.Info("Start A_TranscodeVideo");
            }
            var transcodeLocation   = await context.CallActivityAsync<string>("A_TranscodeVideo", videoLocation); // will put process to sleep while it waits
            if (!context.IsReplaying)
            {
                log.Info("Start A_getThumbnail");
            }

            var thumbnailLocation =  await context.CallActivityAsync<string>("A_getThumbnail", transcodeLocation);
            if (!context.IsReplaying)
            {
                log.Info("Start A_prependIntro");
            }
            var introLocation = await context.CallActivityAsync<string>("A_prependIntro", transcodeLocation);
            return new {transcodeLocation, thumbnailLocation,introLocation};
        }
    }
}

using System.Threading.Tasks;
using Microsoft.Azure.WebJobs;
using Microsoft.Azure.WebJobs.Host;

namespace DurableFunctions
{
    public static class ProcessorActivities
    {
        [FunctionName("A_TranscodeVideo")]
        public static async Task<string> TranscodeVideo( [ActivityTrigger] string inputVideo, TraceWriter log)
        {
            log.Info($" Transcoding {inputVideo}" );
            await Task.Delay(5000);
            return "transcoded.mp4";
        }
        [FunctionName("A_getThumbnail")]
        public static async Task<string> GetThumbnail([ActivityTrigger] string transcoded, TraceWriter log)
        {
            log.Info($" generating Thumbnail for {transcoded}");
            await Task.Delay(5000);
            return "thumbnail.jpg";
        }
        [FunctionName("A_prependIntro")]
        public static async Task<string> PrependIntro([ActivityTrigger] string transcoded, TraceWriter log)
        {
            log.Info($" generating prepended intro for {transcoded}");
            await Task.Delay(5000);
            return "prependedvideo.mp4";
        }

    }
}

{
id: "d96145604927468ba7fb747582d3e49a",
statusQueryGetUri: "http://localhost:7071/admin/extensions/DurableTaskExtension/instances/d96145604927468ba7fb747582d3e49a?taskHub=DurableFunctionsHub&connection=Storage&code=dsYv5U1Rjw6IaQUBMEtEYiGGfhEWjMW8iPcre7QS0aub3GjL6LFnbw==",
sendEventPostUri: "http://localhost:7071/admin/extensions/DurableTaskExtension/instances/d96145604927468ba7fb747582d3e49a/raiseEvent/{eventName}?taskHub=DurableFunctionsHub&connection=Storage&code=dsYv5U1Rjw6IaQUBMEtEYiGGfhEWjMW8iPcre7QS0aub3GjL6LFnbw==",
terminatePostUri: "http://localhost:7071/admin/extensions/DurableTaskExtension/instances/d96145604927468ba7fb747582d3e49a/terminate?reason={text}&taskHub=DurableFunctionsHub&connection=Storage&code=dsYv5U1Rjw6IaQUBMEtEYiGGfhEWjMW8iPcre7QS0aub3GjL6LFnbw=="
}

{
instanceId: "d96145604927468ba7fb747582d3e49a",
runtimeStatus: "Completed",
input: "this.mp4",
customStatus: null,
output: {
transcodeLocation: "transcoded.mp4",
thumbnailLocation: "thumbnail.jpg",
introLocation: "prependedvideo.mp4"
},
createdTime: "2018-07-13T18:31:42Z",
lastUpdatedTime: "2018-07-13T18:32:00Z"
}

I will be following these directions loosely as always:
https://docs.microsoft.com/en-us/azure/service-bus-messaging/service-bus-authentication-and-authorization

Azure Service Bus Setup

Logging to your azure portal, search for Service bus and give it a name, select a subscription type, location and hit create.

Once that is done , create your queue. You can select  Message TTL, Lock duration,  enable dup. detection, enable dead letter queue,  and message sessions.

Console Application Setup

So we have a bus started and a queue that can manage incoming messages. Now we make  an app that can run the process.

Start up a project for a .net core console App, nuget install Microsoft.Azure.ServiceBus, and then I just copy \pasted the code from the linked reference above.  I adjusted the configuration and looked up why the article’s code was using GetAwaiter().GetResult() ( I don’t recall using it before), and turns it out its because when Task is only returned in order to wait for it, you can only  call it this way.

Ran the program as is.

Ok so now my queue has 10 messages in it:

I found a page that has all the information for the attributes that should be in the message payload,
https://docs.microsoft.com/en-us/azure/service-bus-messaging/service-bus-messages-payloads as I wanted to see more details.

I also adapted the code slightly so that it can send , receive\abandon  or receive\complete .

Now keep in mind I was tempted to use the queue’s PeekLock\Abandon  functionality to get all messages and parse the ones I wanted, but that technology is for topics and  I wasn’t trying to create a topic so  I will link you here in case you are interested. This is when found an interesting issue which probably isn’t really an issue. The  Queue client Register Message Handler will continue to retrieve the same messages over and over unless you complete them; abandoning them does not pull them out of the list. It also increases the  delivery attempt count and if it goes past the queue’s max, it throws them into the dead letter count.

The DLQ (dead letter Queue) is interesting because its a subset  of the parent queue, in order to call it you call the original queue name plus $DeadLetterQueue, but then  also found that there is a EntityNameHelper.FormatDeadLetterPath , which is going to be the better way to get these messages. These messages have some interesting data like why they failed:

You can complete them to officially close them out.
Dominic Buford helped me out
https://docs.microsoft.com/en-us/azure/service-bus-messaging/service-bus-fundamentals-hybrid-solutions

You can find my base work here:
https://github.com/EstebanSmits/ServiceBusConsole

Relevant links

Choose between Azure services that deliver messages

Service Bus .NET Samples

https://github.com/Azure/azure-service-bus/tree/master/samples/DotNet/GettingStarted/Microsoft.Azure.ServiceBus/BasicSendReceiveUsingQueueClient