[dba-VB] ControlChars in C#

<<<
And of course all aggravated by "sql server gurus" who execute code through
the command prompt.
>>>
John,

I'm not one of them, do you believe me? :)
I do use more often than anything else MS Access QBE with MS SQL attached
tables to do my SQL "coding" :) - and I'm programming not "toy apps" but
real life multi-layered (ASP.NET) applications with object models with
hundreds and even several thousands of custom classes, many classlib DLLs
etc. 

<<<
In the end I am writing a .Net application that stores everything in
metadata tables but that takes time to design and debug.  
>>>
OK, but what for then you need an "intellisense enabled" MS SQL query
editor? I mean you do not need to write that much of T-SQL queries manually
if you have most of your definitions in metadata tables, do you?...

<<<
The rest of my time is executing queries, one by one, waiting
for the results to be ready to run the next.
>>>
Watch PLINQ to be released soon! I might help you to naturally (and
effortlessly?) execute your "data massage and export" in parallel on
multi-core systems:

http://spellcoder.com/blogs/bashmohandes/archive/2007/10/14/8530.aspx 

http://www.microsoft.com/downloads/details.aspx?FamilyID=e848dc1d-5be3-4941-
8705-024bc7f180ba&displaylang=en 

--
Shamil
 

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, March 25, 2008 9:21 PM
To: 'Discussion concerning Visual Basic and related programming issues.'
Subject: Re: [dba-VB] ControlChars in C#

And of course all aggravated by "sql server gurus" who execute code through
the command prompt.

I need (and am building) a "quick and dirty" script to execute about 20-30
various queries, exports to csv, imports from csvs etc to take an order for
data and turn it into a csv for shipment.  I need that because it takes a
half a day of executing crap by hand to fill an order that should take 5
minutes of my time to specify.  I have exactly two things I need to do to
specify an order, enter a "number of records to export" and modify an
existing view in a template database to pull the right set of data.
Sometimes I have to do a few more things, but even then it is about 1/2 hour
of real work.  The rest of my time is executing queries, one by one, waiting
for the results to be ready to run the next.

In the end I am writing a .Net application that stores everything in
metadata tables but that takes time to design and debug.  However the time
will be well worthwhile if I can fill an order in 5 minutes that takes me a
half day to do by hand. 

John W. Colby
Colby Consulting
www.ColbyConsulting.com