Click here to Skip to main content
15,884,388 members
Home / Discussions / Database
   

Database

 
AnswerRe: C# DELETE FROM Parameter problem Pin
Kornfeld Eliyahu Peter6-Sep-15 2:21
professionalKornfeld Eliyahu Peter6-Sep-15 2:21 
Questionjava Pin
Member 119613805-Sep-15 0:23
Member 119613805-Sep-15 0:23 
SuggestionRe: java Pin
Richard MacCutchan5-Sep-15 0:41
mveRichard MacCutchan5-Sep-15 0:41 
SuggestionWhat should be the choice.. MongoDB or Sql Server? Pin
Schatak2-Sep-15 18:40
professionalSchatak2-Sep-15 18:40 
GeneralRe: What should be the choice.. MongoDB or Sql Server? Pin
CHill603-Sep-15 5:53
mveCHill603-Sep-15 5:53 
GeneralRe: What should be the choice.. MongoDB or Sql Server? Pin
Schatak3-Sep-15 20:22
professionalSchatak3-Sep-15 20:22 
GeneralRe: What should be the choice.. MongoDB or Sql Server? Pin
jschell11-Sep-15 12:28
jschell11-Sep-15 12:28 
GeneralRe: What should be the choice.. MongoDB or Sql Server? Pin
Eddy Vluggen3-Sep-15 8:23
professionalEddy Vluggen3-Sep-15 8:23 
Schatak wrote:
I am going to start a big construction project with MVC. I am confused about Db
choice.
I would recommend postponing the choice.

Schatak wrote:
Although worked with SQL server from past 5 years. but now thinking to use
MongoDB.
They are not the same, and one would perform poor in the area where the other excells. SQL Server would be preferred for relational data, especially if you are on a Microsoft stack.

I cannot determine whether or not MongoDB supports SQL92. It would be nice to know, since;
  • You could postpone the choice of which database-class to use by programming against the IDbConnection interface.
  • Inject any database-driver in there
  • And if you keep your SQL compatible with SQL92, then any database supporting the standard could be used.
SQL92 is not as rich as the Sql dialect of the server, but it does offer the advantage to swap out the database entirely, simply by changing the configuration.

..but in general, you take risks in small and simple projects; it would be very not fun if you had to make a lot of changes in a very large project after some months of work, and breaking it in the process.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

GeneralRe: What should be the choice.. MongoDB or Sql Server? Pin
Jörgen Andersson3-Sep-15 9:14
professionalJörgen Andersson3-Sep-15 9:14 
GeneralRe: What should be the choice.. MongoDB or Sql Server? Pin
Eddy Vluggen3-Sep-15 10:08
professionalEddy Vluggen3-Sep-15 10:08 
GeneralRe: What should be the choice.. MongoDB or Sql Server? Pin
Jörgen Andersson3-Sep-15 9:16
professionalJörgen Andersson3-Sep-15 9:16 
GeneralRe: What should be the choice.. MongoDB or Sql Server? Pin
Schatak3-Sep-15 20:30
professionalSchatak3-Sep-15 20:30 
GeneralRe: What should be the choice.. MongoDB or Sql Server? Pin
jschell11-Sep-15 12:17
jschell11-Sep-15 12:17 
GeneralRe: What should be the choice.. MongoDB or Sql Server? Pin
Herman<T>.Instance23-Sep-15 0:21
Herman<T>.Instance23-Sep-15 0:21 
QuestionPowershell backup and restore SQLscripts Pin
Stephen Holdorf2-Sep-15 13:01
Stephen Holdorf2-Sep-15 13:01 
QuestionRe: Powershell backup and restore SQLscripts Pin
Eddy Vluggen3-Sep-15 8:28
professionalEddy Vluggen3-Sep-15 8:28 
QuestionAbout Triggers Pin
dili12341-Sep-15 20:18
dili12341-Sep-15 20:18 
AnswerRe: About Triggers Pin
GuyThiebaut1-Sep-15 22:18
professionalGuyThiebaut1-Sep-15 22:18 
GeneralRe: About Triggers Pin
dili12347-Sep-15 20:28
dili12347-Sep-15 20:28 
QuestionComposite Key Pin
Gilbert Consellado31-Aug-15 22:26
professionalGilbert Consellado31-Aug-15 22:26 
AnswerRe: Composite Key Pin
Eddy Vluggen31-Aug-15 23:02
professionalEddy Vluggen31-Aug-15 23:02 
GeneralRe: Composite Key Pin
Gilbert Consellado31-Aug-15 23:39
professionalGilbert Consellado31-Aug-15 23:39 
GeneralRe: Composite Key Pin
Eddy Vluggen1-Sep-15 0:18
professionalEddy Vluggen1-Sep-15 0:18 
GeneralRe: Composite Key Pin
Gilbert Consellado1-Sep-15 0:38
professionalGilbert Consellado1-Sep-15 0:38 
GeneralRe: Composite Key Pin
Eddy Vluggen1-Sep-15 1:37
professionalEddy Vluggen1-Sep-15 1:37 

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.