Hi
We're using the castle scheduler component:
http://using.castleproject.org/display/Comp/Castle.Components.Scheduler?showChildren=false
I have a wcf service which creates the tasks and that does it's job fine.
I then have a console app running (will be a windows service eventually)
which
Hi
I got the following DB Setup
Products
- ID
- Name
ProductGroups
- ID
- Name
Products_ProductGroups
- ProductId
- ProductGroupId
If i delete an entire ProductGroup I dont want it to delete the
products unless the products is not associated with another
ProductGroup
Any good way of doing
Yup, overriding SqlType was the only way I could get it working.
Otherwise, the base EnumStringType class generates SQL statements with
the wrong cast. Something like:
INSERT INTO TestTable (State, Id) VALUES ('Preview'::text,
'9dea2a34-566a-45ea-84fd-24b86403ef5b'::uuid)
Which creates an
These enums will never change. There's no reason to add more values
here (and if I ever do, I realize it'll be somewhat of a pain)..
On Sun, Jun 6, 2010 at 9:08 PM, Michael Sync mchls...@gmail.com wrote:
I just check the Mauricio's answer on Stackoverflow.
I have some confusions..
public enum
Yes. It will be a pain.. If those enums are never change then we dont need
to put them in database. I was in situation where we want to allow user to
add those values. For example: We have the project statuses (such as Not
Started, Started, Completed). We stored those values in database. User
I don't believe I explained the situation clear enough. The possible
values for the enum never change. It always must be one of those
values. However, which value it is can change. I have an enum called
OrderState which can be Preview, InQueue, or Completed. It can never
be anything else. I
Ok, it seems that you have to override SqlType when you're using a custom
database type. You can just write a generic class inheriting from
EnumStringTypeT and overriding SqlType and apply that one. See my updated
answer on stackoverflow.
On Mon, Jun 7, 2010 at 8:35 AM, Mike Christensen
Yup, that's exactly what I ended up doing :)
On Mon, Jun 7, 2010 at 6:24 AM, Mauricio Scheffer
mauricioschef...@gmail.com wrote:
Ok, it seems that you have to override SqlType when you're using a custom
database type. You can just write a generic class inheriting from
EnumStringTypeT and
Hi Mark,
I think the way to do this would be the same way doing this in plain
sql, you would:
- get a set of counts of product groups attached to the products
attached to the product group you are looking to delete
- delete every product where the count from previous set is 1
- delete the