DefaultValue and Caption in Dataset Designer

Hi everyone,
Just wondering if someone can explain to me the reasoning behind (and a
possibly workaround) why the DefaultValue and the Description (Caption)
values dont come across to the dataset from a given database. I am using SQL
Server 2000 and have this probhlem in both Visual Studio 2003 and 2005. To
recreate the problem, create a table in SQL Server and give any of the
fields a description and a default value. In visual studio 2005 in the
Dataset Designer add the table you just created. You will see that the
default values and description (caption) for the fields have not been
transferred across into the tableadapter.

Putting constraints such as default values should all be done at the
database level not at the application level and it seems like poor
implementation that these values do not come across automatically. We use
the default value widely in our databases to ensure that null values are not
entered into any of the columns by giving a default value of (''). Having to
go through and add these default values to all columns seems like promoting
very poor design.

Any help is greatly appreciated,
Paul


.

Relevant Pages

  • Re: Is there a maximum size of field caption property in a table?
    ... There are usually multiple possible design solutions. ... ComponentTypeID jumper block, connector, ... ... BLOBs), and properties such as Format, Caption, and Description that don't ... > be in the database than what is in this table. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Changing Switchboard Textbox Title Via Text Document
    ... The general principle is the same however you do this. ... in the frontend of your database create a new table ... the literal string "caption" in the ctl_item field ... Then in your switchboard in the code behind the form put the following ...
    (comp.databases.ms-access)
  • Re: field alias
    ... Display Caption property in the Table Designer window to 'Dept. name' or ... This caption will be use in Browse windopws and as ... Open with MODIFY STRUCTURE or through the database Designer and you can make ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Retrieving table field properties
    ... > properties like caption, description etc ... Description is exposed by the Jet ... the database: Jet is the database. ... Most of the other column properties can be read using ADOX, ...
    (microsoft.public.inetserver.asp.general)
Loading