StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>You could access your data through database views and do your filtering there. </p> <p>Personally I do not like SQL commmands in DataSet definitions. </p> <p>EDIT: </p> <p>There is not a built-in possibility to do this AFAIK. You could make an VS add-in and invoke it on a context menu from Solution Explorer (right click on .xsd) or open DS and invoke add-in from main menu. The add in would then parse xsd and identify select and update text and make corrections. Probably this would be useful only right after generating the DS (drag drop from sql server).</p> <p>For add.in look at:</p> <ul> <li><a href="https://web.archive.org/web/1/http://articles.techrepublic%2ecom%2ecom/5100-10878_11-1045818.html" rel="nofollow noreferrer">Creating a Visual Studio.NET add-in to write SQL statements</a></li> <li><a href="http://www.codeproject.com/KB/macros/LineCounterAddin.aspx" rel="nofollow noreferrer">Writing a Visual Studio 2005 & 2008 Add-In</a></li> <li><a href="http://www.c-sharpcorner.com/UploadFile/mgold/AddIns11292005015631AM/AddIns.aspx" rel="nofollow noreferrer">Tutorial : Creating Visual Studio Add-Ins</a></li> </ul> <p>I personally would go the DB way. Make views that do the filtering for you and add delete triggers on those views that would perform an update instead of delete. This way you are removing the burden to do that on application and make this the responsibility of the person that makes a physical DB model. This would be done once per table. On the contrary you probably have multiple points in code that deal with single table (multiple datasets that use the same db table).</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload