R
Ronald S. Cook
We have a .NET Win app that runs at 12 different cattle feeding lots. Each
lot runs an isolated instance of our app using its own SQL Server instance.
For overall settings specific to a feedlot, we're maintaining those values
right now in the database. But I'm not sure its the best way to do it. You
see, we have a table "tblFeedlot" with about 20 columns BUT then only one
record in the table.
I thought maybe the table should have just two columns "Name" and "Value" to
and have 20 records, but then the datatype would have to be varchar(100) I
suppose and we'd have to d alot of validating/converting. But maybe this is
the better way to go?
Or do you recommend another way? Would there be some sort of app.config
specific to each feedlot that we stored somewhere?
Thanks,
Ron
lot runs an isolated instance of our app using its own SQL Server instance.
For overall settings specific to a feedlot, we're maintaining those values
right now in the database. But I'm not sure its the best way to do it. You
see, we have a table "tblFeedlot" with about 20 columns BUT then only one
record in the table.
I thought maybe the table should have just two columns "Name" and "Value" to
and have 20 records, but then the datatype would have to be varchar(100) I
suppose and we'd have to d alot of validating/converting. But maybe this is
the better way to go?
Or do you recommend another way? Would there be some sort of app.config
specific to each feedlot that we stored somewhere?
Thanks,
Ron