Can One Letter Break Your App!?
Parameterizing Entity Framework queries can let EF reuse a compiled query shape and help the database reuse its query plan.
Transcript 1 topic
Avoid culture-specific casing
0:00Ever have a bug that only shows up on one machine? Meet the Turkish I, where too lower can change your strings in unexpected ways. Lowercasing uses your current culture. So the uppercase I can lowercase into a dotless whatever that is, not the ASCII I with a dot that you expect. But did you notice that the string equals handled it correctly?
That's because the string comparison using ordinal ignore case is culture agnostic. So don't normalize. Compare correctly, and your global users will thank you.
Sign in to join in. Reading needs nothing.