Eric M Russell (3/6/2014)

---

It's true that by coding batch processing logic within the application, your SQL code can be simplified and constructed in a more cross-platform fashion. Basic SELECT, INSERT,...

DEK46656 (3/6/2014)

---

dmbaker (3/6/2014)

---

At the moment I would think the best approach would be is to design the database “correctly” and implement the GUI through something like MVC. Leave as...

At the moment I would think the best approach would be is to design the database “correctly” and implement the GUI through something like MVC. Leave as much of...

Entity Framework can do a "mass delete" by executing an arbitrary SQL statement. It's arguable as to whether that's actually EF since you're essentially "stepping out" of the framework to...

My apologies, it wasn't clear in your initial post that that this was the case and it's someting that seems to be often forgotten. I'm certainly glad to hear it...

Step 0 - Talk to the business

Are you sure you need a data warehouse at all? Discuss needs with your users and make sure you understand the business. If you...

Did you mean "salient?" I suppose salacious would work, but it gives your post a whole different meaning. 😀

Can you post more details? Sounds like you're using .NET (since you mention app.config) but knowing what language you're coding would be helpful (e.g. c#? VB.NET?) as would what version...

I think that "database abstraction layer" isn't really what you think it is, or at least your view is incomplete. Microsoft's Entity Framework, as well as other ORM tools, are...

"When they need to construct a class in C#, they don't heave out a prosthetic GUI to do it. They just cut code"

Well, I think one could call Visual Studio...

patrickmcginnis59 10839 (5/13/2013)

---

dmbaker (5/13/2013)

---

Really? That's a pretty broad brush you're using...

Really? That's a pretty broad brush you're using there. I don't...

Well, we don't use VS 2012 yet and I've not tried this with VS 2012, but I'll give it a shot.

1) Get Sql Server Data Tools! Download and install the...

Any chance you can upgrade to Visual Studio 2010 or later? SQL Server Data Tools, which is available in 2010/2012 is pretty darn useful, and it makes database development much...

I find it interesting that nobody has mentioned that building software, and modifying it, has an associated cost -- somebody has to pay for it.

When users ask for modifications to...