-
Thanks for the reply. Let's assume that I need to require that the user re-enter their data when a concurrency violation occurs. What do I need to do in code to trap this error? What error would I look for? Thanks!
-
I just read the blog post about the new "Built-In EntitySpaces Concurrency Mechanism" ( http://www.entityspaces.net/blog/2009/10/27/The+BuiltIn+EntitySpaces+Concurrency+Mechanism.aspx ) This looks easy enough to implement, but what do I need to do in my code to use it? Do I need to trap an error and display a message to the user? What's
-
Out of habbit, I usually set the ID to -1 for new records. If I do this, then save, it's not returning the updated autogenerated identity value. Dim newBusinessInfo As New DAL.BusinessInfo With newBusinessInfo .Id = -1 .BusinessName = "some business name" End With newBusinessInfo.Save() If I don't set the ID and then save, it does
-
I just upgraded to the latest version (2009.2.1012.0). Previously, after I saved an entity my primary key column (ID, int, Identity=Yes) would contain the value of the autogenerated identity after the save was executed. Now, it's not working the same. I'm sure this is something easy, but I'm not finding a solution on the forums. thanks!
-
Thanks. After sitting here thinking for a while, it dawned on me what you were suggesting. Generate the templates on both databases, but only use a connection to the XYZ.mdb. So, I did a little test and it works! Now I have two ES projects, one for each database. I generate the templates into the same Custom and Generated folders. Thanks for your help
-
I guess I could generate them from the source tables in the ABC.mdb, but the beauty of the Access linked tables is that the tables appear to be "local" in the XYZ.mdb. I could always have a second connection to the ABC.mdb, but that would be creating much more work. It looks like ES isn't recognizing the "MS Access Linked Tables" as tables. Could this
-
I'm developing a project using ES v.2009.1.0209.0 that connects to a MS Access database. The Access database (XYZ.mdb) has several "linked tables". These linked tables in XYZ.mdb are connecting to the "source tables" in the Access database (ABC.mdb). When I try to generate using ES's templates it displays the tables existing in XYZ, but does not show
-
Yes, I did get errors. I commented out the primary key functions/subs. Probably not what I should have done. I have since, created primary keys in the tables, generated the code and then changed back the original Access database without the primary keys. This seems to work well. Do you see any problems with this? Is there a way to create a primary key
-
I have several tables in an Access database that do not have primary keys. (This wasn't my idea, it's just the way it is.) Code: Try Dim cashDrawer As New DAL.CC.BusinessObjects.CashDrawers cashDrawer.Query.Where(cashDrawer.Query.Id.Equal( "CD01" )) If cashDrawer.Query.Load() Then cashDrawer.TransactionNumber += 1 cashDrawer.Save() End If Catch ex As
-
I need to dump all data from all tables in my application's SQL Server database to MS Access. Is there anything in EntitySpaces that would make creating these tables easy? Anyway to open an entity and write it's columns/keys etc to create a new table in another database? Thanks!