> IMHO It sounds like you are doing something that the table adaptor might > not be the best fit for. I have never been a big fan of loading a > million records (or anything close to that in a data set) on a client > machine. No matter what solution you use to refresh you data it's going > to be expensive on the server and the client. You may want to consider > writing a stored procedure for your inserts that has a returning value > of the generator for each insert that you do. Then instead of using a > table adaptor, you can write a class and use a generic collection to > store the data (much faster). You will have to write the S,I,U,D methods > yourself, but you can then capture the return values for each row you > updated or insert. This is a very common practice where I work, and then > it is easy to get the row ID of the row being inserted.
I already wrote ORM library and it uses generics, nullable types, anonymous delegates and so on. We use this libruary with object datasourcec in ASP.NET projects, but it's not convenient as for me to use such library for desktop applications. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
