Click here to Skip to main content
14,335,920 members
   

C#

 
GeneralRe: What is the best way to create your Database (tables..etc) using C# ? Pin
Abdalla Ben Omran10-Sep-19 22:16
memberAbdalla Ben Omran10-Sep-19 22:16 
AnswerRe: What is the best way to create your Database (tables..etc) using C# ? Pin
MadMyche11-Sep-19 1:43
mveMadMyche11-Sep-19 1:43 
PraiseRe: What is the best way to create your Database (tables..etc) using C# ? Pin
Maciej Los11-Sep-19 1:59
protectorMaciej Los11-Sep-19 1:59 
GeneralRe: What is the best way to create your Database (tables..etc) using C# ? Pin
MadMyche11-Sep-19 3:50
mveMadMyche11-Sep-19 3:50 
Generallaziness is a reason for progress Pin
Maciej Los11-Sep-19 4:03
protectorMaciej Los11-Sep-19 4:03 
GeneralRe: laziness is a reason for progress Pin
MadMyche11-Sep-19 4:10
mveMadMyche11-Sep-19 4:10 
GeneralRe: What is the best way to create your Database (tables..etc) using C# ? Pin
Mycroft Holmes11-Sep-19 13:48
memberMycroft Holmes11-Sep-19 13:48 
AnswerRe: What is the best way to create your Database (tables..etc) using C# ? Pin
C. David Johnson13-Sep-19 7:51
memberC. David Johnson13-Sep-19 7:51 
Having been a developer for over 20 years, and a SQL DBA and Administrator since 6.5. My Preference is to design the database using Management Studio. I do it this way

#1. Design the raw tables include the fields for the Foreign keys BUT do not link them yet
#2. Design your Clustered indexes I will name them IDX_tablename
#3. Be lazy and use the Database Diagrams tool to define your Foreign Keys

My reason for doing this if the DB is designed correctly your app will be far more stable. If you design your foreign keys first it becomes your clustered indexes and normally you will cluster on a name or account number and not the ID.
GeneralRe: What is the best way to create your Database (tables..etc) using C# ? Pin
Abdalla Ben Omran22-Sep-19 23:35
memberAbdalla Ben Omran22-Sep-19 23:35 
AnswerRe: What is the best way to create your Database (tables..etc) using C# ? Pin
Jörgen Andersson13-Sep-19 7:52
protectorJörgen Andersson13-Sep-19 7:52 
QuestionCopy text from console window Pin
Gene M9-Sep-19 1:01
memberGene M9-Sep-19 1:01 
AnswerRe: Copy text from console window Pin
Richard MacCutchan9-Sep-19 1:46
protectorRichard MacCutchan9-Sep-19 1:46 
AnswerRe: Copy text from console window Pin
OriginalGriff9-Sep-19 1:46
protectorOriginalGriff9-Sep-19 1:46 
AnswerRe: Copy text from console window Pin
Gerry Schmitz9-Sep-19 2:58
mveGerry Schmitz9-Sep-19 2:58 
AnswerRe: Copy text from console window Pin
Sharp Ninja9-Sep-19 4:35
memberSharp Ninja9-Sep-19 4:35 
GeneralRe: Copy text from console window Pin
Richard MacCutchan9-Sep-19 6:03
protectorRichard MacCutchan9-Sep-19 6:03 
GeneralRe: Copy text from console window Pin
Sharp Ninja10-Sep-19 2:57
memberSharp Ninja10-Sep-19 2:57 
GeneralRe: Copy text from console window Pin
Richard Deeming10-Sep-19 4:13
mveRichard Deeming10-Sep-19 4:13 
AnswerRe: Copy text from console window Pin
Gene M9-Sep-19 20:31
memberGene M9-Sep-19 20:31 
GeneralRe: Copy text from console window Pin
Richard MacCutchan9-Sep-19 21:16
protectorRichard MacCutchan9-Sep-19 21:16 
GeneralRe: Copy text from console window Pin
Dave Kreskowiak10-Sep-19 3:13
mveDave Kreskowiak10-Sep-19 3:13 
GeneralRe: Copy text from console window Pin
Gene M10-Sep-19 7:39
memberGene M10-Sep-19 7:39 
GeneralRe: Copy text from console window Pin
Dave Kreskowiak10-Sep-19 8:49
mveDave Kreskowiak10-Sep-19 8:49 
GeneralRe: Copy text from console window Pin
Gene M10-Sep-19 11:28
memberGene M10-Sep-19 11:28 
GeneralRe: Copy text from console window Pin
Dave Kreskowiak10-Sep-19 11:43
mveDave Kreskowiak10-Sep-19 11:43 

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.