@Richard.Hein:I don't think you really need to be overly polite in ending the interview with someone who is either lying about what they know, or is actually just inept. That is ridiculous that someone with claimed experience couldn't do that. My first semester students could code that kind of thing.
Discussions
-
-
OK, step one, breathe easy.
Step 2: paste the code at the "top" means at the top of the class, which is inside the curly braces that encompass the class definition. From your frustration it would seem that you haven't done any C# before because I looked at the demo code and it was instantly clear what to do.
Step 3: in the future something like this more appropriately would go under the "Tech Off" forum rather than Coffeehouse... or perhaps more directly to a site geared toward coding assistance like Stack Overflow.
-
@vesuvius: can they arrange to let you work all your hours in 4 days? A girl I work with does 4-10s in order to do something similar.
-
@W3bbo:Now that I looked back at the code we used it just built the insert statements and did some basic sql prepration (like escaping single quotes, etc.) because the data wasn't public so SQL injection wasn't a risk we had to mitigate, so we didn't use parameterized commands, we did just concatenate in a string builder and execute it. It served our purposes, and for simple data migration, where the inputs are known it may suffice as well. Other than that, perhaps a DTS/SSIS type package or bulk insert would offer better performance if that is what you are after.
-
If you append more than 1 parameterized statement per command instance you should see better performance than that. I did that and had over 100,000 records per minute against a dev machine with separate disks for data and log, but just standard IDE HDDs.
-
We just mount a pad of paper with a pencil to the fridge (well, it is magnetized, not really mounted) and it does great to keep track of a shopping list, and then, amazingly, you can tear off the page and take it with you to the store.
Efficient, cheap.
-
You can call it a brain drain, but he also could have been head-hunted, which means at least they have some desirable individuals.
Remember, most people have more interests than just staying at the same company. Perhaps this helps him scratch some other itch.
-
@rhm:actually, I watched the keynote from the US and the content was blocked for me as well.
-
#1 only ... same for varchar( as in, both sounds the same)
