Code First, do you like it?

[pkfox]

Get the database right first, the rest is easy

We can’t stop here, this is bat country - Hunter S Thompson RIP

[Sascha Lefevre]

:thumbsup:

If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

[Gavin Coates]

But how many times has someone updated one, and forgot to update the other? At least with auto-generation, you're one click away from regenerating. With code first, you need to sit down and verify every recent change to ensure it has been incorporated.

[Slacker007]

Learn ASP.NET Online – Microsoft Virtual Academy[^] Under "Creating and configuring models" --> Creating models --> around 23:40 but start at around 22:00 to get some intro context. I heard that the SNAFU they had during the demo happens a lot to people, especially those who are trying to get up to speed with "code first".

[Sascha Lefevre]

Thank you! Will take a look..

If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

[Slacker007]

Link to comment with link to video [^]

[Frank Alviani]

Definitely prefer a Sumatra or French Roast.:suss:

My long term goal is to live forever. So far, so good...

[Lost User]

Tx :)

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

[jeron1]

Whilst I prefer the one's that on sale. :)

"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment "Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst "I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle

[Amarnath S]

:thumbsup:

[Nish Nishant]

Can you elaborate on that please?

Regards, Nish

---

Website: www.voidnish.com Blog: voidnish.wordpress.com

[PIEBALDconsult]

Frack no. It's the epitome of taking a very bad idea and following it ad absurdum.

[PIEBALDconsult]

GuyThiebaut wrote:

if you know what you are doing

Exactly; from what I see, the "latest and greatest shiniest new" tools are designed for a different demographic. :suss: If you don't know what you're doing, better have someone else do it for you.

[Jacquers]

Here is an example click[^] It can generate scripts and apply them to the database based on changes made to the POCO classes used.

[dazfuller]

I do indeed. You need to spend some time ensuring that your entity changes will produce the database design you're expecting (e.g. table-per-class, table-per-hierarchy etc...) and you may want to write some helpers to make adding things like indexes a bit easier but otherwise I've found it to be a very neat way of doing things. One thing to consider though is your initial database creation, for this I'd suggest either having a script to create the database and manage the configuration of it (not my preferred) or create a Database Project and output a DACPAC (much better and has better deployment options if you're using MS SQL Server). The reason for this is that if you use something like EF migrations then you'll get default database settings and sizings when it's created which you may not want, using a DACPAC means you get control over things like collation and recovery modes.

Eagles may soar, but weasels don't get sucked into jet engines

[RUs123]

Hm, how does your heart manage with all that caffeine? I'm genuinely curious as I've tried drinking more coffee but it only made my heart beat faster, my mind was still very interested in sleeping. :) Or maybe I haven't developed a tolerance yet - haven't been drinking coffee regularly for too long.

[Flo Lee]

I was raised with manual DB creation and then creating code that accesses the DB. This worked well with the waterfall model, where (theoretically) no changes would appear after planning and design (on paper) were over. But in recent years, as things became more "agile" (read: people do not want to make decisions, people want to change their mind very often, people just lack knowing the full story) I started to change my mind. We had lots of problems in our application when we were adding fields to an already existing complex DB and then implementing the handling code. Sometimes datatypes were wrong. Sometimes fieldnames were misspelled etc especially when the change was not implemented by just only one person. Another strong point for code-first entities design was the thing with SVN: While we had good practice already with versioning our code, the DB was hard to track in SVN. Ultimately people started to checkin binary backups from SQL Server, but you could not diff them etc. With code-first we now have a singular, unique description of the Db in Plaintext, with matching datatypes and compile-time error checks. Our test cycles are much easier now. BR Florian

[SPoss]

what about different flavours of coffee? does it help? Its normal coffee first (medium don't want to shock the heart to early, got work to do), then mid-morning, may be a orange flavoured coffee or cameral. Just received some Chocolate Mint, but not sure I like this one.

[dietmar paul schoder]

I would not think about it. I would do it. We did it, it is a paradise.

[Quirkafleeg]

You mean diving into the code isn't a good idea? Youtube analogy[^]