Questions tagged [database-development]
The database-development tag has no summary.
109 questions
18
votes
5
answers
4k
views
Is LINQ to SQL dead?
Is there any reason to keep using Linq to SQL, or is it better to move to ORM techniques like EF, NHibernate etc.
We are using Linq to SQL in a new large enterprise application that will exist for a ...
- 11.1k
2
votes
2
answers
452
views
Best way to store revision information for quick access to view or revert changes
What I am looking for is the most optimal solution for storing content revisions in an MSSQL database. We have an application that allows users to make changes to small HTML content blocks similar to ...
- 713
16
votes
5
answers
446
views
Should my multi-server RDBMS or my Application handle database Referential Integrity?
Should items like Foreign Keys, Constraints, Default Values, and so on be handled by the database management system (in this case, MS SQL 2005) or the application? I have heard opinions from both ...
- 24k
31
votes
9
answers
12k
views
Should a primary key be immutable?
A recent question on stackoverflow provoked a discussion about the immutability of primary keys. I had thought that it was a kind of rule that primary keys should be immutable. If there is a chance ...
- 413
6
votes
2
answers
2k
views
How to read and understand ER diagrams
I've been handed the ER diagram for a quite complex database.
Complex to me at least, 849 tables. One of the architects says to understand the code, you need to understand the database and ...
- 467
19
votes
14
answers
4k
views
What are the benefits of using database abstraction by ORM? [closed]
I'm starting to use the ORM recommended by the framework I choose, and though I like the idea of the added layer of abstraction the ORM provides, I'm starting to realize what this really means. It ...
- 778
45
votes
11
answers
5k
views
What are the arguments against or for putting application logic in the database layer? [closed]
Most software developers want to keep application logic in the application layer, and it probably feels natural for us to keep it here. Database developers seem to want to put application logic in the ...
- 2,185
3
votes
1
answer
663
views
What is the best toolset for developing an enterprise application for SMBs?
Need a Free, Fast(development and runtime) and Reliable(transactions and locking) tool set for creating an enterprise application for SMBs.
I'm thinking of an application framework + UI framework + ...
- 39
7
votes
1
answer
1k
views
What are some easy-to-implement scaffolding systems? [closed]
Often when stating a new project I'll require a "quick 'n' dirty" content management solution.
Ideally something that can read my database schema and generated HTML forms.
Previously I've used; ...
- 2,071