GenerateDBDirectMethods not being generated
Posted: Thu 12 May 2011 20:09
I am working in VS 2005 trying to add a table adapter with the Table Adapter Configuration Wizard. Everything works except that the Insert, Update and Delete methods are not being generated. I am doing a select statement from a single table. It looks like this:
SELECT _rid, created, person_type, address_type, isprimary, actnum, "name", address1, address2, city, "state", zip, geo_confidence, geo_latitude,
geo_longitude, agent_visibility, client_visible, status, owner_type, owner_id, verified, verified_by_type, verified_by_id, verified_datetime, "source",
notes, first_update_submitted, integration_id, _last_updated
FROM ars.actaddresses
This table does have a primary key (_rid).
I have tried every combination of the advanced options without success. This worked with version 4.55 of dotconnect but I had to upgrade to fix a Reporting Services issue and now I have this problem. Please advise.
Version of Postgres is 8.4
Version of dotConnect is 5.10.96.0.
Version of Visual Studio 2005 is 8.0.50727.762 (SP.050727-7600)
.NET Framework version is 2.0.50727 SP2
XP Professional version 2002 SP 3 (32 bit)
I am using the using the Professional version of dotConnect. The name of the download file is dcpostgres510pro.exe.
SELECT _rid, created, person_type, address_type, isprimary, actnum, "name", address1, address2, city, "state", zip, geo_confidence, geo_latitude,
geo_longitude, agent_visibility, client_visible, status, owner_type, owner_id, verified, verified_by_type, verified_by_id, verified_datetime, "source",
notes, first_update_submitted, integration_id, _last_updated
FROM ars.actaddresses
This table does have a primary key (_rid).
I have tried every combination of the advanced options without success. This worked with version 4.55 of dotconnect but I had to upgrade to fix a Reporting Services issue and now I have this problem. Please advise.
Version of Postgres is 8.4
Version of dotConnect is 5.10.96.0.
Version of Visual Studio 2005 is 8.0.50727.762 (SP.050727-7600)
.NET Framework version is 2.0.50727 SP2
XP Professional version 2002 SP 3 (32 bit)
I am using the using the Professional version of dotConnect. The name of the download file is dcpostgres510pro.exe.