Click here to Skip to main content
14,665,922 members
Home » Discussions » C#
   

C#

 
GeneralRe: Multiple Classes, same name Pin
Nelek22-Jun-20 5:58
protectorNelek22-Jun-20 5:58 
GeneralRe: Multiple Classes, same name Pin
Dave Kreskowiak16-Jun-20 3:22
mveDave Kreskowiak16-Jun-20 3:22 
GeneralRe: Multiple Classes, same name Pin
Wiep Corbier16-Jun-20 3:26
MemberWiep Corbier16-Jun-20 3:26 
GeneralRe: Multiple Classes, same name Pin
Dave Kreskowiak16-Jun-20 3:42
mveDave Kreskowiak16-Jun-20 3:42 
GeneralRe: Multiple Classes, same name Pin
ZurdoDev16-Jun-20 4:00
mveZurdoDev16-Jun-20 4:00 
AnswerRe: Multiple Classes, same name Pin
Pete O'Hanlon16-Jun-20 1:45
subeditorPete O'Hanlon16-Jun-20 1:45 
GeneralRe: Multiple Classes, same name Pin
Wiep Corbier16-Jun-20 1:58
MemberWiep Corbier16-Jun-20 1:58 
GeneralRe: Multiple Classes, same name Pin
OriginalGriff16-Jun-20 2:28
mveOriginalGriff16-Jun-20 2:28 
Wiep Corbier wrote:
I store Skills as a string in the database.

They are stored like this: Skill 1|Skill 2|Skill 3|Skill 4

And that all on it's own is a poor idea. Do you realise how much work it is in SQL to change a skill when you store it like that? First off, it wastes space, secondly it's prone to user error and two skills that are described differently but are actually the same, and thirdly because it's hard to work with for anything more complex than INSERT and DELETE operations.

For example, suppose HR realises a mistake has been made: EmployeeX doesn't have any knowledge in "Skill 2", it's "Skill 5" he knows. Now write the SQL to fix that ... and bear in mind that you might have "Skill 2", and "Skill 21", "Skill 22", "Skill 23", ... so you can't rely on string replace functions or you will cause further errors.
Oh, and while you are at it, fix the spelling mistake that Deirdre always makes in "Skill 17" but no one else does.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!

GeneralRe: Multiple Classes, same name Pin
Wiep Corbier16-Jun-20 2:33
MemberWiep Corbier16-Jun-20 2:33 
GeneralRe: Multiple Classes, same name Pin
OriginalGriff16-Jun-20 2:45
mveOriginalGriff16-Jun-20 2:45 
GeneralRe: Multiple Classes, same name Pin
Wiep Corbier16-Jun-20 3:10
MemberWiep Corbier16-Jun-20 3:10 
GeneralRe: Multiple Classes, same name Pin
Dave Kreskowiak16-Jun-20 3:32
mveDave Kreskowiak16-Jun-20 3:32 
GeneralRe: Multiple Classes, same name Pin
Wiep Corbier16-Jun-20 3:54
MemberWiep Corbier16-Jun-20 3:54 
AnswerRe: Multiple Classes, same name Pin
ZurdoDev16-Jun-20 4:04
mveZurdoDev16-Jun-20 4:04 
GeneralRe: Multiple Classes, same name Pin
Wiep Corbier16-Jun-20 4:21
MemberWiep Corbier16-Jun-20 4:21 
GeneralRe: Multiple Classes, same name Pin
Wiep Corbier16-Jun-20 9:32
MemberWiep Corbier16-Jun-20 9:32 
GeneralRe: Multiple Classes, same name Pin
OriginalGriff16-Jun-20 4:27
mveOriginalGriff16-Jun-20 4:27 
GeneralRe: Multiple Classes, same name Pin
Member 798912216-Jun-20 4:28
MemberMember 798912216-Jun-20 4:28 
GeneralRe: Multiple Classes, same name Pin
Wiep Corbier16-Jun-20 4:32
MemberWiep Corbier16-Jun-20 4:32 
GeneralRe: Multiple Classes, same name Pin
Member 798912216-Jun-20 5:52
MemberMember 798912216-Jun-20 5:52 
GeneralRe: Multiple Classes, same name Pin
Wiep Corbier16-Jun-20 6:04
MemberWiep Corbier16-Jun-20 6:04 
GeneralRe: Multiple Classes, same name Pin
OriginalGriff16-Jun-20 4:28
mveOriginalGriff16-Jun-20 4:28 
GeneralRe: Multiple Classes, same name Pin
Pete O'Hanlon16-Jun-20 3:32
subeditorPete O'Hanlon16-Jun-20 3:32 
GeneralRe: Multiple Classes, same name Pin
Member 798912216-Jun-20 4:19
MemberMember 798912216-Jun-20 4:19 
GeneralRe: Multiple Classes, same name Pin
Wiep Corbier16-Jun-20 4:46
MemberWiep Corbier16-Jun-20 4:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.