sasha wrote: > 1) For inserting component knows ID because it calls GEN_ID before > inserting and than inserts record with alredy known id > > 2) For updating it use something like @ID variable > > So i don't see any problems...
You can do this in ADO.NET. First you get the ID, i.e. select gen_id('aaa', 1) from rdb$database. Then perform the insert. Similar to update, but you know the id from ... anywhere. >> IMHO there's no way how to get the update result from DB defaultly (no >> matter that it can be completely changed during insert process) - you can >> use returning, or load it by i.e. id or something like this. > > I already understood this. It was easy to do this in delphi, so i'm > wondering... It's not about Delphi or .NET or whatever. It's a FB by design. The only one way is any knowledge about the data (id, returning, gen_id). > > Last ~2 years i developed ASP.NET applications. In that applications we > use own ORM libruary. Seems i'll try to use it for desktops too because > ADO.NET concepts still looks strande for me :-( Don't worry. ;) ADO.NET is easy. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------------------------------------------------- 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