how does it know which connection string to use?

[doph]

I am new to EasyObjects and I used the getting started manuals to use MyGeneration to generate stored procs, abstruct and concrete classes. It did pretty well and I tried a little test with it:

Restaurant r = new Restaurant();
r.AddNew();
r.ID = Guid.NewGuid();
r.Name = TextBox1.Text;
r.Catering = CheckBoxList1.Items[0].Selected;
r.Valet = CheckBoxList1.Items[1].Selected;
r.Delivery = CheckBoxList1.Items[2].Selected;
r.Save();

it failes with null ref ex on Database db = GetDatabase();

no wonder - it does not know which database to connect to - there is a connection string in web.config but how do I tell the generated code to use it?

Many thanks and sorry for a dumb question.

[mgnoonan]

Hi doph,

That's actually an Enterprise Library thing. If you open your web.config or app.config file in the EL Configuration Tool and click on the Data Access Application Block, one of the node properties is DefaultDatabase. Set this to the name of the connection string you want to use as the default.

As an alternative, you can always specify which connection string you want in code:

Code: Select all

Restaurant r = new Restaurant();
r.DatabaseInstanceName = \"LocalSqlServer\";
r.AddNew();
...
etc.


[doph]

Thanks a lot, mgnoonan, this helped!