You searched for the word(s): userid:615074

More Search Options

RSS Available

• Re: AutoGen=true??

  Are you able to help? Kind regards Paul

  Posted to Blinq Preview (Forum) by redtap on 9/19/2006

• Re: AutoGen=true??

  Hi Polita, getdate() is a method called in SQL from the default value field. So the field isn't an identity field but rather a normal field with a default value setup ( getdate() ). If no date is supplied when the record is inserted the current date and time is placed in the field. Unfortunately Blinq on update supplies this field with a null value, unless I manually go into the autogenerated c# mapping code and set the field to be AutoGen=true; Although this works it stops me supplying a date

  Posted to Blinq Preview (Forum) by redtap on 9/7/2006

• AutoGen=true??

  Hello! In my database table I am setting up default values in my fields. For example in my field 'created' I am autogenerating the date and time using getdate() so whenever a row is inserted the datetime is automatically entered. How is this mapped through using Blinq and Sqlmetal on the field mappings?At present it is carrying it through as a normal field. I would expect, although possibly incorrectly to find AutoGen=true?? Can someone explain the mapping process for autogenerated fields (not Id

  Posted to Blinq Preview (Forum) by redtap on 8/11/2006

• Re: Getting the Identity of the last Inserted row!

  Ok, Ok Its finally clicked for me...being an old sql developer getting my head round things like this gets confusing so to take this confusion away I've put together an example below which will hopefully help out others who were also confused...I hope I wasn't the only one... using TestDb; namespace LINQConsoleApplication1 { class Program { static void Main( string [] args) { // Insert example ********************** // create the database connection Test db = new Test ( "Data Source=********;Initial

  Posted to Blinq Preview (Forum) by redtap on 8/7/2006

• Re: Getting the Identity of the last Inserted row!

  Sorry to keep barking on about this, but I have a project I need to finish and really need to crack this problem! Many thanks

  Posted to Blinq Preview (Forum) by redtap on 8/7/2006

• Re: Getting the Identity of the last Inserted row!

  Thanks Dinesh and Polita for getting back to and helping me out. I'm still finding things a little unclear in regards to this line. I quote " If you are inserting a single object, then the id of that object is patched up using @@identity/scope_identity. So if you are looking for the id of the inserted object, that is available." Here is a simplified idea for what I'm trying to achieve... I have an object called 'Nomination' each 'Nomination' object can have a number of file objects attached to it

  Posted to Blinq Preview (Forum) by redtap on 8/6/2006

• Re: Getting the Identity of the last Inserted row!

  Yes, its an identity column, when a record is inserted the identity is auto generated by the db, this is the value i wish to return after the insert, many thanks!

  Posted to Blinq Preview (Forum) by redtap on 8/6/2006

• Re: Getting the Identity of the last Inserted row!

  Please help! I will resolve to begging!!!

  Posted to Blinq Preview (Forum) by redtap on 8/6/2006

• Getting the Identity of the last Inserted row!

  Can anyone tell me how to get the identity of the last inserted row? I'm using DLINQ so please don't tell me how to do this in SQL as I know this. In SQL I would use SCOPE_IDENTITY() or @@IDENTITY (generally not the latter) Please help! I have project to be finished ASAP and this is the only bit holding me back! Thanks !

  Posted to Blinq Preview (Forum) by redtap on 8/4/2006

• QueryStringParameter confusion...

  If you see below it has case 'Awardz_Nominations' how do I pass that value into tableName so I can get only the nominations within a certain award, rather than all awards which its bringing back at the moment with below code. Also how are the QueryStringParameter's working within the objectdatasource? I'm not seeing a query string passed in Code is here: public static IQueryable< Nomination > GetNominations( string tableName, Int32 Nominations_AwardId, string sortExpression, int startRowIndex

  Posted to Blinq Preview (Forum) by redtap on 8/2/2006