ADO.NET |DataDirectory| where is this documented?

by

|DataDirectory| is a substitution string so you can configure the location of your database file separately.

So instead of:

SqlConnection c = new SqlConnection (
   @"Data Source=.\SQLDB; AttachDbFilename=C:\MyDB\Database.mdf;Initial Catalog=Master");

you do the following:

// Set |DataDirectory| value
AppDomain.CurrentDomain.SetData("DataDirectory", "C:\myDB");

// SQL Connection String with |DataDirectory| substitution string
SqlConnection c = new SqlConnection (
   @"Data Source=.\SQLDB; AttachDbFilename=|DataDirectory|\Database.mdf;Initial Catalog=Master");

More Related Contents:

  1. How to use Select method of DataTable
  2. Calling stored procedure with return value
  3. Get output parameter value in ADO.NET
  4. OleDbCommand parameters order and priority
  5. When should “SqlDbType” and “size” be used when adding SqlCommand Parameters?
  6. SQL command INSERT is working but the data not appear in table
  7. Return value from SQL Server Insert command using c#
  8. Entity Framework with NOLOCK
  9. Under what circumstances is an SqlConnection automatically enlisted in an ambient TransactionScope Transaction?
  10. How to pass sqlparameter to IN()? [duplicate]
  11. Invalid attempt to read when no data is present
  12. How do I return multiple result sets with SqlCommand?
  13. Populate data table from data reader
  14. Difference with Parameters.Add and Parameters.AddWithValue
  15. How to save image in database using C# [closed]
  16. Encrypt password in App.config
  17. DbArithmeticExpression arguments must have a numeric common type
  18. Connection timeout for SQL server
  19. MultipleActiveResultSets=True or multiple connections?
  20. Getting binary data using SqlDataReader
  21. Creating a SQL Server table from a C# datatable
  22. How should I multiple insert multiple records?
  23. SQL: Update a row and returning a column value with 1 query
  24. Returning a SqlDataReader
  25. I need a workaround for Excel Guessing Data Types problem
  26. How do I extract data from a DataTable?
  27. Reading a date using DataReader
  28. What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
  29. How do I connect to a SQL database from C#?
  30. How can I Pass a Table Name to SqlCommand?

Leave a Comment