Re: Amazming....but curious...

One more thing:
If you are using stored procedures for all of your work, it should not matter, as you are explicitly choosing the columns. As long as you do not remove an item, you are in complete control. If you add to schema, you can still use the old method until you are ready to update the procs and the XSDs.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

*********************************************
Think outside the box!
*********************************************
"TJ" <TJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:BFDDCD8D-3A66-433C-8E8B-6A800F11A941@xxxxxxxxxxxxxxxx
Hi,

Enviornment : Visual Studio .NET 2005 and SQL Server 2005

I created one stored procedure, let's say GetData()...Basically, what it
does is that it just returns data from table. (Select [A],[B] from [Test]
where id=@xxxxxxxxxxxxx like this...)

I created a strongly typed data set with that table, and set the GetData
procedure for Fill Query in table adapter....

It works fine....
there are two questions come to my mind...

1. When I tested to insert some records through generated dataset, it
worked.(I don't have any store procedure for insertion) It makes sense, but
is this insertion done by store procedure or just SQL text?...I guess SQL
query text...It seems to me that insert query automatically was created based
on the selected data(from GetData proceudre)....Does it mean that if I use
strongly typed data set with stored proceudre, am I losing some benefit of
store procedure?.....or insertion store procedure just created on the fly???

2. Once schema has been generated, what if the underlying database changes
so that I need to update the schema to generate new class??....Only way I
found the easiest way is dropping the table again on the XSD designer after
removing the old one......That's not very desirable way..too much work...set
any parameters again....Is there any way to synchronize with the DB easy and
efficiently?

Thanks ,

..................................................TJ



.

Relevant Pages

  • Re: Amazming....but curious...
    ... You can create a code generator to create the XSD, but there is nothing built-in, in Visual Studio, that will sync contents. ... procedure for Fill Query in table adapter.... ... is this insertion done by store procedure or just SQL text?...I guess SQL ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Amazming....but curious...
    ... Stored Procedures can run faster than a lot of generated code. ... you will find that SQL "on the fly" can actually be faster if you hit a condition that forces procedure recompile or replan. ... I guess store procedure is different story. ... typed dataset was be able to query insert or update without the sp in my ...
    (microsoft.public.dotnet.framework.adonet)
  • How do I do Paging through a large dataset via Stored Procedures
    ... Paging by dynamically altering the SQL Query ... Create stored procedures ... SELECT * FROM STUDENTS ...
    (microsoft.public.dotnet.framework.adonet)
  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help with Stored Procedure
    ... I did mean stuff like system stored procedures (even ... build the query, compile it, and optimize it, then, then this is less ... very not easy using dynamic sql. ...
    (microsoft.public.sqlserver.programming)
Loading