Re: Chicken or Egg: SQL vs Strongly Typed DataSet

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 02/03/04 

Date: Mon, 2 Feb 2004 20:26:17 -0800

That code is in the designers. I expect MS thought that it's the purview of
the tools to do the DDL--VS.NET provides some of those tools, SQL EM more,
SQL-DMO even more. ADOX is a COM-based throwback that works best for JET.
Yes, it's tough to get the Framework to do this, but I expect there are also
third-party tools you can use. 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"_eddie_" <_nomail_@_nospam_.com> wrote in message
news:oact10hch361o2j4lvsj2b787d5n22vn8r@4ax.com...
> On Sun, 1 Feb 2004 18:38:58 -0800, "William \(Bill\) Vaughn"
> <billvaRemoveThis@nwlink.com> wrote:
>
> >ADO.NET has no facility to create database tables--even from strongly
typed
> >DataSets.
>
> Surprising, considering the amount of automatic code generation in
> VS.NET!  You'd think they could have written some code to do this
> easily.
>
> I've also been looking for code to generate Connection strings.  I did
> figure out how to use the same dialog that VS.NET uses, but it appears
> that this is still Com code.  Still a bit awkward for distribution.

Relevant Pages

  • Re: Visual Studio Sucks
    ... "Data Environment" I am referring to. ... designers at all since they really have no commonalities between them ... I could bring up a new query builder via the keyboard by doing Shift ... When working with SQL Server - why the heck did they remove the ...
    (microsoft.public.vsnet.ide)
  • Re: Visual Studio Sucks
    ... This is especially true in VS.NET's "Webforms" designers... ... What a complete load of garbage the Query Builder IDE is. ... Why when I choose "Stop Outlining" in a Stored Procedure text window, from the context menu, does it do nothing? ... I have found this to be true of SQL Server Management Studio also, a huge backwards step in terms of usability for anyone who uses the product on a daily basis. ...
    (microsoft.public.vsnet.ide)
  • Re: Named Mistakes and Questionable Practices
    ... This is how he handled dups in RM II. ... lost out to Standard SQL. ... It is so pathetic how the machine designers look to what the software designers are doing and the software designers look to what the machine designers are doing and all we ever get is cpu's that reflect a lot of bio-feedback. ...
    (comp.databases.theory)
  • Re: Visual Studio Sucks
    ... You can't compare WinForms and WebForms ... This is especially true in VS.NET's "Webforms" designers... ... What a complete load of garbage the Query Builder IDE is. ... When working with SQL Server - why the heck did they remove the ...
    (microsoft.public.vsnet.ide)