convert object returned from Stored Proc to Guid

convert object returned from Stored Proc to Guid

• ParthP

  Hi,

  what type of object does syl_GroupInsert return If

  group.GroupID = (Guid)db.ExecuteScalar(...);

  doesn't work, you could also try

  group.GroupID = new Guid(db.ExecuteScalar(...).ToString());

  Andrej

  
  
  

• Ramanujam Sampath

  a Guid from our Stored Procedure - T-SQL Guid created throught the newid() function in T-SQL. The Guid is our primary key in the Groups table. We use an int in all our other tables as primary key but in this instance we need the primary key to be a Guid which throughs us off a little bit.
  

• Novozh

  I take it group.GroupID is of Guid type....

  Don't convert the result to byte array... Try converting it to string and use that in new Guid constructor...

  group.GroupID = new Guid(db.ExecuteScalar(...).ToString());

  Andrej

  
  
  

• Tylerk

  Tried this but it is not working....................

  private static bool Insert(GroupInfo group)

  {

  group.GroupID = Guid.Empty;

  group.GroupID = new Guid((db.ExecuteScalar("syl_GroupInsert",

  group.GroupName,

  group.OwnerID,

  group.SecondaryContactID,

  group.DateAdded,

  group.FullURL,

  group.AvailableCredit,

  group.StorageSpaceID,

  group.StorageSpaceUsed,

  group.StorageWarned,

  group.StorageExceeded,

  group.GroupStatusID,

  group.CurrencyID,

  group.LanguageID,

  group.IsActive))).ToByteArray();

  return (group.GroupID != Guid.Empty);

  }

  
  
• convert object returned from Stored Proc to Guid