ADO.NETFor discussion about ADO.NET. Topics such as question regarding the System.Data namespace are appropriate. Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.
You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
Hi, I have just started using visual web developer 2005 and I was wandering if there is a way to separate SQL statements in some separate file because my .cs file gets really messy wiht code and SQL mixed together.
Usually you'd create a data access layer class that contains all the data access methods with the sql code. Another way to separate the SQL from the .NET code is to use stored procedure. Then the .NET side of things is a little simpler and you also get performance gains by having compiled procedures on the database side.
SQL in .cs file
Linear Mode
