problem creating ref criteria and ref table sql problem

Monday, February 06, 2012

Home

Downloads

License

Forums

Contact

Web Site

Instructions

In order to add new threads or reply to existing posts, you have to be logged-in. If you are not registered yet, you need to register first, and then login with your personal credentials.

CslaFactory Forums

Search Home

Home

Support

CslaFactory CTP

problem creating ref criteria and ref table sql problem

7/18/2008 12:50 PM

StephenDenisEdwards

stephenedwards.virtualituk.com/
Joined: 7/17/2008

Posts: 1

problem creating ref criteria and ref table sql problem

Hi,

I have just been having a play around with CSLAFactory. I had a couple of issues which I thought I would mention here.

The ZeroToMany FriendOf reference generates the following supporting table:

BEGIN

CREATE TABLE dbo.[contactmanager_ContactFriendOfConnects](

[ContactID] uniqueidentifier NOT NULL,

[ContactID] uniqueidentifier NOT NULL

) ON [PRIMARY]

END

- which of course cannot be created in the database.

I was also unable to create the Role List Criteria because when I try to add properties the Role_id does not appear in the dropdown list (as it does in the demo video).

It is probably early days yet, but I was wondering if you have any thoughts about how the tool might be used with an existing database?

I’ve only been playing with it for a day or so, but it looks very promising.

Thanks

Stephen Edwards

7/20/2008 11:09 PM

Marcel

Joined: 9/18/2007

Posts: 52

Re: problem creating ref criteria and ref table sql problem

Hi Stephen,

thank you for your hints. The first one (0..many self-references) is an issue we weren't really aware of. We will consider both: disabling 0..many self-references and extending the templates to solve it.

Your second concern is not really an issue, because the March CTP of CslaFactory is simply not capable of using NameValueLists in criteria signatures. The video tutorial you mentioned is based on a later version.

Building new models for existing databases and structures is a big point. With the CTP version, you can not even choose the name of the table a certain BusinessObject persists in. This will change in the release version. A second point are database schemas. From the first beta on, you will be able to select a database schema for every BusinessObject in the model.

Although we stronlgy believe Ids should be Guids, there are quite some users out there that prefer Integers. We did not really decide how to handle this, yet - the current version only generates Guids. This might be a problem, if your existing database relies on Integer-Ids.

Marcel

Page 1 of 1

Home

Support

CslaFactory CTP

problem creating ref criteria and ref table sql problem

UsersOnline

	Membership:
	Latest: erymn
	Past 24 Hours: 1
	Prev. 24 Hours: 0
	Overall: 1585

	People Online:
	Visitors: 4
	Members: 0
	Total: 4