This blog will have all kinds of posts about Wally McClure. In it, there will be tons of .NET and computer programming posts as well as Wally's views on life in general. As you might guess, this site and blog help you get More Wally in your life. What more could anyone want? .NET, ADO.NET, ASP.NET, AJAX, Atlas, Microsoft AJAX Library, ASP.NET AJAX, and now Windows Azure............follow me on twitter at
Wally
I'm a database type of guy. I like data. I work with data all the time. One thing that is common across all database is the need to retrieve the row identifier of a record that was just inserted. Oracle has a sequences. Sql Server has scope_identity(). I've been learning the Sqlite database on the iPhone and have been accessing it through MonoTouch using ADO.NET. With SqlLite, you call "last_insert_rowid()" on the current connection. This allows a program to retrieve the primary key that was just inserted. The method runs on the current connection. Its actually related more to @@identity in Sql Server as it returns the last rowid of the last record that was inserted on the current connection.