I was trying ActieWriter for the first time for evaluating prupose, so, I
tested it with one fo the legacy DBs I have access to.
Then I found myself having some weird problems.
1. I have a table "Units" which has a reference to tble "SystemUsers". I
map the "Units" table only but not the "SystemUsers", ahen I try to call
"FindAll" on a different table that references "Units". I get a terrifying
error like:
[[could not update: [ConsoleApplication5.Units#45][SQL: UPDATE dbo.Units
SET Name = ?, BusinessPartner_UserId = ?, Department_ID = ? WHERE ID = ?]]]
What I don't understand is: why is it even trying to update when the only
stsatement in the entire project is FindAll!! (it's a test console project).
2. When I tried to solve the previous problem by adding "SystemUsers" in
the ActiveWriter designer from Server Explorer, no relation was created
between this table and any other table, although it should have been
automatically related to, say at least the "Units" table
3. This one sounds the simplest: When I run the program after adding the
"SystemUsers" table (which has a column of sqlType(size) Binary(100) -a
Password related field-), I get the error:
"Could not determine type for: Binary"
This is once i try to "touch" the DB (AKA, calling "FindAll" on a
different entity). See code below:
The DB is hosted in SQL Server 2005. My Schema is simple: I have a (just the
relevant parts):
- SystemUsers Table
- UserId - int identity PK
- Password - Binary(100)
- Departments Table
- Manager_UserId referring to SystemUsers PK
- Units Table
- Department_ID referring to Departments PK
- BusinessPartner_UserId referring to SystemUsers PK
What do you think could the problems be?
Regards,
--
Mohamed Meligy
Information Analyst (.Net Technologies) – Applications Delivery - TDG
Injazat Data Systems
P.O. Box: 8230 Abu Dhabi, UAE.
Phone: +971 2 6992700
Direct: +971 2 4045385
Mobile: +971 50 2623624
E-mail: [email protected]
Weblog: http://weblogs.asp.net/meligy
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Castle Project Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/castle-project-users?hl=en
-~----------~----~----~----~------~----~------~--~---
