Showing related tags and posts accross the entire site.
-
I read about GUIDs and is use as primary key to solve aoffline and replication problems. I need your advice if GUIDs will provide any benefit for the following design. I am currently working in an application where it has mulitple actors (users accounts) types.we used guids as primary keys for actors...
-
SQL2005NewSequentialID.zip Original Thread is loacted here http://community.codesmithtools.com/forums/t/2902.aspx I have run into the newsequentialid() as I to need to create a disconnected pc application. I have made changes to the latest SVN templates 677 I belive is what I start with. The changes...
-
My primary reason is that using the OUTPUT clause kills a whole bunch of birds with one stone. Getting the actual values back from the row solves a bunch of questions and issues i've seen around here related to default values. There doesn't seem to be any support for the OUTPUT clause at the...
-
I'd rather rely on sql server's newsequentialid and output clauses to solve this Is there any particular reason why? I can't see any benefit to doing so, and it has downsides, such as the fact that it requires a database round-trip before you get your Guid, and OUTPUT is slow : you have to...
-
This patch creates a new static class called Comb with one method NewGuid(). The GUIDs produced by this method are ordered, thus they will reduce index fragmentation in SQL Server. More details are in the file Comb.cs[t]. It is in respone to the end of this thread : http://community.codesmithtools.com...
-
Hey folks, Is there any way we could integrate this into the next nightly release. Or, more importantly, is this something worth working in? I ran up against the problem again recently. I would do it myself but am without a computer (personal computer, I have my work computer but I don't want to...
-
I have a WCF web service that I've created with takes various Entities that are generated by netTiers as parameters and return values to it's methods. Here's the implementation to a pretty simple method in the service: public TList<Lists> FetchLists(string criteria) { return DataRepository...
-
So, is there no one using the UNIQUEIDENTIFIER as the PK of their tables and generating with .netTiers? If anyone has the solution to this problem, please post it! Thanks!