Skip to main content

Posts

Showing posts from 2019

Code Snippets

To help speed up my development process, I decided to go down the path of creating code snippets for code blocks that I end up copying and pasting a lot.  I have published these to GitHub and will keep adding to them as I find the need to add more.  If you have any that you would like to add, please feel free to send them my way.  Here is a link to the git hub respiratory where I am keeping the code snippets.

https://github.com/JamesStuder/CodeSnippets

If you would like more information on howto create your own code snippets check out Microsoft's Documentation (Link Below).

https://docs.microsoft.com/en-us/visualstudio/ide/code-snippets?view=vs-2019

SQL Script To Generate C# Model

While working on a data migration project that uses C# and Azure Functions.  I found myself in the need to generate a model of the table(s).  While doing a Google search I came across the following blog post that has a script to generate the model properties for me.  Simply replace the table name variable at the top of the script with the table name you want to generate the properties for.  You may also need to include the schema name in the table name if you have multiple tables with the same name, just under different schema's.  I did make one change to it in the select @ result line.  It was adding a blank line in between each property, so I removed the new line.


declare @TableName sysname = 'TABLE_NAME' declare @Result varchar(max) = 'public class ' + @TableName + ' {' select @Result = @Result + ' public ' + (CASE WHEN ColumnName = 'RowVersion' THEN 'byte[]' ELSE ColumnType END) + NullableSign + ' ' + Column…

SQL Script to Create Enums For Table Columns

While working on a data migration project, using C# and Azure Functions, I found myself needing to create enums to use in my code for the columns.  Some of the tables where vary large (over 200 columns) and doing this manually would have taken a while to do it.  So, I wrote the below SQL script to create the enums for me.  To use this simply replace the table and schema variables with the schema and table name you want to generate the enums for.


declare @Table sysname = '<INSERT TABLE NAME HERE>'; declare @Schema sysname = 'INSERT SCHEMA NAME HERE'; declare @Result varchar(max) = 'public enum ' + @Table + 'Columns' + ' {' select @Result = CONCAT(@Result, ' ',ColName, ' = ', SUM(ColNum), ',') from ( select COLUMN_NAME as ColName, SUM(ORDINAL_POSITION - 1) as ColNum from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = @Table AND TABLE_SCHEMA = @Schema group by CO…

UPDATED: Setup Non-Interactive User with Non-Expiring Password

A while ago, I wrote a blog post on setting up a non-interactive user with a non-expiring password.  Since writing that post, the process has changes and I couldn't find much documentation on the process.  The part of setting up the non-interactive user hasn't changed:

Setup Non-Interactive User:
Create a user in the Office 365 admin center.  Be sure to assign a Dynamics 365 (online) license to the account.Go to Dynamics 365 (online).Go to Settings > Security.Choose Users > Enabled Users, and then click a user’s full name.In the user form, scroll down under Administration to the Client Access License (CAL) Information section and select Non-interactive for Access Mode.  You then need to remove the Dynamics 365 (online) license from the account.Go to the Office 365 admin center.Click Users > Active Users.Choose the non-interactive user account and under Product licenses, click Edit.Turn off the Dynamics 365 (online) license, and then click Save > Close multiple times.…