|
Access has a bad reputation among developers, but it actually works perfectly fine for some situations where you don't want to have to install sql server, or where portability is desired. The only time I would warn against using Access is if your application will be handling more than a few concurrent users. If it's a single user app, it will work just fine.
Other options:
0: sql compact (portable, but doesn't allow views)
1: sql server as a cloud service (such as Azure) (portability becomes a non-issue, but requires an internet connection)
2: sqllite (never used it, but also a single-file format)
...or, you could write the application to support multiple database types using oledb objects. This is what we do here...customers can use either Access or SQL Server depending on their needs. I'd still stick with Access for the design and query building. (my preference when working with Access is actually using Access 2003 as I hate the interface for the newer versions. Good luck!
"Go forth into the source" - Neal Morse
|
|
|
|
|
Actually I'm going to bitch at you for using the wrong forum, the DB forums is perfect for this type of discussion!
It should depend on your goals, if you want to get into database and LOB development then use SQL Server and SSMS, it is the tool used by many departmental and SME shops.
Enterprise tend to use Oracle or what I call the pig iron databases, monsters that need a DBA to set up and run. Read years of experience needed to use properly.
Access is the other end of the scale and should be avoided like the plague.
I despise EF, too much of a black box and leaves junior developers with limited knowledge of data structures and TSQL. Having said that I have 2 tools DBops, a minimalist DAL and ClassBuilder a code generator for all the grunt work that EF does. The difference is I wrote the bloody things, I know how and why they work and can instruct juniors in its use in 15 minutes. I also encourage others in the team to contribute and smack them if they over engineer .
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Forgive me - but I'm not going to answer the question you asked - because code first vs. database first is (IMHO) immaterial.
You'll find your own preference, or your circumstances (such as a pre-existing database you have to work with), will dictate what you do. (Also, personally, I'm old school - I create my C# classes, and my Data Definition Language scripts - CREATE TABLE ... - at the same time. I like having precise control of my schema, foreign key constraints, indexes, primary keys, etc. AND I like being the author of my POCOs).
If you're new to using databases, there's a chance you're new to data modelling in the relational world. Understanding what makes a good (i.e. easy to understand, reliable and efficient in time and size) schema is far more important than how you translate between database objects and programming language objects.
|
|
|
|
|
|
This could be a case where the kid knows he will get get/make more money down the road? Why sell if you don't have to? Not in it for the money? Who knows...
|
|
|
|
|
Slacker007 wrote: where the kid knows he will get get/make more money down the road? Yes, he believes so.
Slacker007 wrote: Why sell if you don't have to? I'll take a guaranteed 30 million over a possible unknown amount later on. With that 30 million there is all kinds of good I could do with it.
I'm just not a big risk taker.
I'd hate to see some other company that has more resources get to market before him with something similar and then he end up with nothing at all.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
RyanDev wrote: I'm just not a big risk taker.
Neither am I.
|
|
|
|
|
I guess the kid is not yet bored with what he is doing
... such stuff as dreams are made on
|
|
|
|
|
Ya, it takes guts to pass up that much money.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
I could have dated Kate Upton. I'm waiting for a better offer.
Peter Wasser
"The whole problem with the world is that fools and fanatics are always so certain of themselves, and wiser people so full of doubts." - Bertrand Russell
|
|
|
|
|
How is that going for you?
|
|
|
|
|
A bird in the hand is worth two in the bush.
Peter Wasser
"The whole problem with the world is that fools and fanatics are always so certain of themselves, and wiser people so full of doubts." - Bertrand Russell
|
|
|
|
|
Not sure about her bush, but if I remember correctly she is a bit top heavy.
|
|
|
|
|
Oh sh*t, I went to google images, not something you should do at the office computer in Singapore.
However I can see the attraction!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Haha.
Not a good thing to do if your girlfriend is sneaking up on you either.
That kind of trouble I can live without.
|
|
|
|
|
I always take these things with a grain of salt. In many developed countries a 14 year old is not allowed to enter into a legal contract, so how can he possibly have a company and\or make deals?
Also the idea may sound good but the potential for public liability claims will be too great to make it viable. If you are at a venue there is usually a responsibility on the venue to provide first aid so would you rather see a qualified first aider with known good equipment or trust something random from a vending machine where you don't know how old the goods are or if they are still fit for purpose?
I keep to buying nothing from vending machines but Diet Coke, Double Deckers and used panties.
|
|
|
|
|
F-ES Sitecore wrote: In many developed countries a 14 year old is not allowed to enter into a legal contract, so how can he possibly have a company and\or make deals? In the US, I'm pretty sure the parents would still have control of the money.
F-ES Sitecore wrote: Also the idea may sound good but the potential for public liability claims will be too great to make it viable. If you are at a venue there is usually a responsibility on the venue to provide first aid so would you rather see a qualified first aider with known good equipment or trust something random from a vending machine where you don't know how old the goods are or if they are still fit for purpose? Exactly. There are reasons why this may not work. Which is why I say to take the money and run and don't look back.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
RyanDev wrote: In the US, I'm pretty sure the parents would still have control of the money.
Personally I think in these types of stories the parents actually do everything and are responsible for everything, but they know if they claim their doe-eyed child is the one doing it they get news coverage from the "human interest" angle.
There was quite a good example of a child who apparently owned multiple Ferraris. He was interviewed by various journalists etc, and of course it was all just a hoax. You'll find it on YouTube. Where kids and large amounts of money\business is involved I'm always suspicious.
|
|
|
|
|
We are all just jealous.
|
|
|
|
|
Very much so.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
At least one honest guy around.
|
|
|
|
|
I'm not sure I'd want to be 14 again!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Maybe if you could carry the knowledge you have now with you.
But I was more thinking of the money, though.
Would be nice with a pile of cash to lean back on.
|
|
|
|
|
That's a great (interesting) story.
You'd think he'd have sold because as soon as you hear the idea, it becomes a commodity -- a (seemingly) easy thing to reproduce by any large company. Is the idea of a vending machine that sells first-aid kits even patentable? Not sure.
I see he has already sold 100 units to (on spec) to Six-Flags and his vending machine design is very simple (which is perfect and totally necessary for his product). But it still feels like a large company will come along and "borrow" the idea.
|
|
|
|
|
raddevus wrote: still feels like a large company will come along and "borrow" the idea. That's why I'd take the 30 million and run. There are many companies with resources that could beat him to market with a better product. I hope not for his sake.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|