Karen Payne MVP
@KarenPayneMVP
Followers
5,484
Following
108
Media
1,728
Statuses
6,813
Microsoft MVP x 10, passion for sports cars 🏎, Microsoft technology📠, teacher, She,her,hers. 🟢 Developer advocate
Oregon USA
Joined July 2009
Don't wanna be here?
Send us removal request.
Explore trending content on Musk Viewer
LINGORM ROMAND 1STPOPUP
• 280825 Tweets
WIN FANCON IN HK
• 117923 Tweets
Manchester United
• 98200 Tweets
CONGRATS LISA
• 92881 Tweets
#withMUSIC
• 83063 Tweets
ダービー
• 62735 Tweets
Manchester City
• 40983 Tweets
Man United
• 40237 Tweets
#ラプ様と愉快な仲間たち
• 38340 Tweets
攻殻機動隊
• 37410 Tweets
May Patrick Joys Live🪽
• 36411 Tweets
SB19 WITH NINANGPUREGOLD
• 34219 Tweets
FAYEYOKO IZEMARISSA
• 29341 Tweets
サイエンスSARU
• 24753 Tweets
Viva la Patria
• 23652 Tweets
Mujra
• 20836 Tweets
クマフェス
• 16249 Tweets
Feliz Día de la Patria
• 14696 Tweets
ジャスティンミラノ
• 10954 Tweets
消費税減税
• 10650 Tweets
Revolución de Mayo
• 10458 Tweets
Pinned Tweet
Did you know when logging exceptions you can remove the path to lines of code?
29
91
695
When writing code, do you include empty lines for readability?
464
59
1K
Cool library for dump any object in a structured and colorful way into the Console, Trace, Debug events or your own custom output.
My simple test with EF Core 8
10
34
298
Just took a massive class project from .NET Framework 4.5.0 to .NET Core 7, 27 issues, all ambiguous namespacce issues fixed in 20 minutes. Entire upgrade 45 minutes. Next up, benchmarking.
25
11
283
Are you using FluentValidation?
Did you know about including rules? Using Include can help in reusability.
11
29
271
EF Core tip
When using raw SQL where the statement is long, consider creating a separate method that contains the SQL as shown belong.
Benefits
🔹Cleaner code
🔹Statements are easy to drop in e.g. from SSMS
21
24
252
Visual Studio tip: many of Microsoft methods provide sample usage by pressing CTRL+ALT+'
9
37
216
How to download files from the web in a .csproj file.
11
19
205
Setup for EF Core configuration for development, staging and production.
12
22
198
Did you know about pseudovariable $returnvalue to the return value of a .NET method?
20
18
192
Did you know about adding a dependency by dragging and dropping?
13
22
190
Have you worked with implicit operator?
(My focus for today)
31
18
182
Chinook is a sample database available for SQL Server, Oracle, MySQL. Good database to learn from.
1
40
182
Async guidance by David Fowl
(posted this earlier but did not show up)
6
32
176
Question
When interacting with databases, do you write asynchronous or synchronous methods or both?
And yes stored procedures were not used here.
39
17
176
77
15
175
Question of the day
Primary constructors (1) or conventional (2)?
96
10
170
Question of the day (T-SQL)
There are two choices, CASE or IIF ?
54
21
173
Question of the day
When not using records which is your preference?
73
18
163
In Visual Studio, do have this option checked/enabled?
If not you should.
8
19
154
Think it was 20 years ago when I dropped Borland Delphi for .NET
14
1
147
FluentValidation InlineValidator example
🔹Person model uses Inline validation
🔹Developer model regular validator
3
18
144
Question of the day
Which is your preference?
(do not overthink localization)
125
16
143
What are your essential Visual Studio extensions❓
Mine
📍 EF Core Power Tools
📍 ReSharper
📍 Markdown Editor
📍 Image preview
35
9
134
Question of the day
Do you use the stash feature of Git in Visual Studio?
106
4
132
Question of the day
Validate Birth date using DataAnnotations (1) or FluentValidation (2)?
26
17
131
Question of the day
Which is your preferred null check?
114
11
128
Did you know Enum.TryParse has a ignore case option?
5
10
130
C# Challenge of the day
Given a string with numbers bracketed how would you extract to a float array?
No chance of nulls and all values will represent floats.
(answer posted tomorrow for those not playing)
29
12
125
Tip for C# raw string literals, storing SQL statement as shown below.
In this case, the statement was written in SSMS using RedGates SQL-Prompt. All statements are stored in a class for statements only.
14
16
117
Essential VS2022 extensions (free) 🧵
Feel free to add yours/
15
20
118
Question, you have an application that has customers from different countries but for this application we only want customers from Germany, no other countries. In the country table Germany identifier is 9. With that, what is wrong with the following method
33
10
116
Been answering questions on many forums for years and wonder when a developer gets some experience with C# or VB .NET they never take the time to learn the basics of generics?
Example 1 allows a developer to use a CheckedListBox with a list of string or other type and keep code
11
13
113
Question of the day
Single character or full name variable in Lambda?
77
7
107
System.Text.Json rearrange order of properties during serialization.
6
13
111
"Gentle introduction to Generic Repository Pattern with C#" by
@KarenPayneMVP
#DEVCommunity
7
15
105
Question on C# validators
What is your preference?
I prefer FluentValidation over Data annotations
31
5
107
Any interest in creating dotnet tools? Below is a sample with an interface using Spectre.Console, accessing SQL-Server databases.
2
9
107
EF Core 8 - Computed columns
Source code, part of an ongoing repository for EF Core 8
2
12
102
Question
Who is actively working on enterprise solutions using Blazor in a fulltime job?
Not looking for those who have side projects.
76
8
101
Question came up for importing Excel to SQL-Server. Person was rather vague but took a stab at it.
Here is my solution (a newer version than post which uses both Dapper and EF Core). Uses an NuGet package ExcelMapper which works great.
12
14
99
Question of the day
Do you have a clean Program.cs ?
25
6
96
EF Core SaveChanges/Interceptor audit to json and log to file using SeriLog.
Source
2
10
95
Dapper/Json/SQL-Server
Was looking a Microsoft SQL-Server examples, found one on using Dapper and had a library I've not seen before for working with objects and string arrays to allow working with json.
My version
Source code
0
10
96
When writing rules for class properties using FluentValidation NuGet package where there are the same rules for various classes consider the following. Implement an interface with common properties and create a validator for them followed by including them in each class as per
3
13
95
Passion outside of coding:
My
#1
passion outside of coding is driving my sports cars modified for extremely curvy roads which we have plenty of in and around Oregon. Since it rains a lot here both cars have ceramic coating on the body and windows.
What is your passion?
10
1
94
Currently converting a .NET Framework 4.6 class proect to .NET Core 8, my wheelhouse in that is one of my specialties.
15
1
93
Here are a couple of useful string extension methods.
4
14
91
When adding a new record to a Microsoft SQL-Server table using C#, there are two ways to write an INSERT statement. The first, using two queries, second a single query.
Note: In the OUTPUT, Id is the property in a Person class and the primary key.
3
14
92
Question of the day
Do you use compiled queries for EF Core?
(and know when to use them)
7
8
90
Question of the day
Convention method (1) or Extension method (2)
48
11
86
New for Data Annotations in net8
AllowedValuesAttribute and DeniedValuesAttribute
Note that AllowedValues is case sensitive.
3
5
86
Simple example for IComparer<T> and primary constructors.
1
6
85
Just took a class with 164 lines of code using connection, command objects and parameters to 64 lines with Dapper with DataTable not list.
Prior code
14
9
83
Simple method to validate a connection string for Core or Razor Pages. Connectionstrings models ConnectionStrings in appsettings.json
1
12
82
For Visual Studio where do you store projects?
- C:\VisualStudio
- C:\VisualStudio2022
- Other
214
4
83
Collection Expressions (C
#12
) done with a model rather than a list of int like I've seen time and time again.
Source
7
5
84
Question of the day
Which method would use to read values from appsettings.json?
43
8
81
Tip for DistinctBy
You can pass more than one property.
Source
4
11
83
While working with EF Core 8 got side tracked taking SQL to different methods to translate the SQL below.
Question of the day
Which version would you use?
(BenchmarkDotNet results are very close)
10
5
81
Learn the basics to working with generics in C# and code reuse.
Windows forms was used so that its easier to understand but what is shown once understood its easy to transfer to other project types.
One example of many
1
11
80
One of the best features I think for, in this case C# are extension methods yet there are developers
🔹Who don't care for them
🔹That are unaware of them
Example from a question asked at Microsoft forums.
Then there are developers who write code in a
8
10
79
SSMS Question
What is your favorite extension?
Mine is Redgate Search
11
6
80
Do you know about the site CodeMaze?
The site has a wealth of great information and in many cases has benchmarks.
Good example, can a string represent an int for instance.
My versions.
7
9
78
Question of the day
Which is your preference, conventional or collection initialization?
50
3
77