"dbuchanan" <dbuchanan@newsgroup.nospamwrote in message
news:OmSrmZNwHHA.5036@TK2MSFTNGP03.phx.gbl...
Quote:
Hello Gregory,
>
#1 - Question:
Quote:
>First, you can have the .config file deploy with the app by right
>clicking and choosing to have it added to the compilation.
>
Where is this that option? When I right click the file in solution
explorer I see these:
Open
Open With...
Exclude From Project
Cut
Copy
Delete
Rename
Properties
>
When I right-click the design surface of the App.Config I see:
View Data Grid
Insert Snippet...
Surround With...
Go To Definition
Breakpoint >
Go To Disassembly
Cut
Copy
Paste
Outlining >
Properties
>
So how do I deploy the App.Config file into the applicaton release folder?
Sorry, it is in the Properties window. Copy to Output Directory. Only works
on the application, AFAIK, not libraries (see below).
Quote:
#2 - Question:
Quote:
>the config is always at application level and not library level...
>Even if you created at library level...
>
What do you mean by "application level" and "library level"?
Whatever piece is actually running (web, windows, console, windows service)
has the config. it sounds like your DAL is compiled as a separate project
and is referenced by your application.
Quote:
#3 - Question:
Quote:
>the TableAdapters are where you are really worried about, not the XSD
>
Why? the TableAdapters refer directly to the XSD and if the XSD is right
will not the TableAdapter function properly?
You can port an XSD anywhere, as it is merely a schema definition. When you
add TableAdapters, you start having code
Quote:
#4 - Question:
Quote:
>To rewire, either ... or right click the XSD and choose the menu item
>that reconfigures the XSD (forget the name of the option).
>
Where do I right-click the XSD? When I right click the XSD file in
solution explorer I see this:
Open
Open With...
Exclude From Project
Cut
Copy
Delete
Rename
Properties
>
When I right-click the design surface I see:
Add
Paste
Select All
Show Relation Labels
Preview Data...
View Code
Properties
On the XSD file, you should see Run Custom Tool. I was probably thinking
about WSDL (service references) when I wrote this originally, but the Run
Custom Tool should fix broken XSDs. I have not tried with TableAdapters sans
web.config entries in the past, however.
Quote:
I believe I have been able to solve the wiring this way;
>
I added the App.Config file to the data access layer project. Then, by
editing the Value (ConnectionString) in the Settings.Settings under the
Project Properties it automatically added the connectionString value to
the .config file (along with adding the connectionString to the
Settings.Designer.cs file too). After doing a release building the config
file appeared in the dataAccessLayer\bin\Release folder. - But the .config
file did NOT appear in the Application\bin\Release folder. That is still
the big problem!
Config is always at the application level, not in the library projects
referenced by the application.
Quote:
#5 - Question:
One last question. I have an MSDN Pro subscription and I have decision
authority for how this applicaiton is constructed. Would you suggest that
I complete this project using Visual Studio 2007 (Orcas)? Is there an easy
learning curve? (By the way I am working on Vista x64 if that has any
influence.)
Orcas gives you more options. If you can wait to release until later this
year (Go Live license) or next year (RTM) I would consider heading this
direction. If fall, you have to gauge how squeamish the execs will be with
Go Live versus a release product. (Go Live means there will be support for
RTM "upgrade").
In Orcas, you have the option of separating your data sets into DAL and
business object components. This allows you to keep the tricky parts, like
TableAdapters, from the definition. Much cleaner. There are some neat
webcasts on this already.
In addition, you can use LINQ to query the database in a neutral way. Simply
switching out LINQ libraries is the path to move from one type of server to
another. It is not quite that simple at present, but I think they can get
there.
Quote:
Summary:
The wiring is solved.
The deployment is NOT solved.
Please reply to questions above.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)
************************************************
Think outside the box!
************************************************