This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I'm new to Lightspeed, and ORMs in general -- was stubbornly holding onto custom, uber-specific DALs. But I have seen the light... speed. :) I'm using the beta and had a couple questions... When using the designer there isn't a SqlServer2008 enum for the database provider. Is this as intended? Also, I noticed when I create an entity representing a new table (designer), I can change the Identity Method to IdentityColumn and when I push to the DB everything is as it should be. However, if I create the entity, leaving the Identity Method to its default, push the changes to the DB, then change the Identity Method to IdentityColumn, and push to the DB it does not think there are any changes and, predictably, the table doesn't get altered. Inversely, if I make the identity change in the DB and try to sync from the DB, it doesn't recognize the change either. |
|
|
The designer SqlServer2005 provider also works with 2008. (However, if you use SQL Server 2008-specific data types like spatial data types, then your app.config/web.config/LightSpeedContext must specify SqlServer2008, even though the designer will still show 2005.) You are correct that the designer does not currently automatically try to change a column from IDENTITY to non-IDENTITY. Making this change requires manual attention to ID allocation (what do you do with the IDs that have been allocated already) and we therefore do it only at initial table creation time. So you will need to make this change separately in the LightSpeed designer and in your database design tool (e.g. SSMS). |
|
|
That's what I've been doing on both points; just wanted to make sure I wasn't missing something. Thanks! |
|