db.ExecuteNonQuery(dbCommand) > 0) always returns -1

• peerless

  Ten Centuries

  Points: 1114

  More actions

  January 17, 2011 at 8:16 pm

  #97793

  the below "if (db.ExecuteNonQuery(dbCommand) > 0)"

  returns -1

  public static bool IsUserInFavoriteList(int userNameID, int favoriteUserNameID)

  {

  bool result = false;

  Database db = OmegaLoveSqlDataHelper.CreateConnection(ConnnectionString);

  DbCommand dbCommand = db.GetStoredProcCommand("prc_IsUserInFavouriteList");

  db.AddInParameter(dbCommand, "UserNameID", DbType.Int32, userNameID);

  db.AddInParameter(dbCommand, "FavoriteUserNameID", DbType.Int32, favoriteUserNameID);

  if (db.ExecuteNonQuery(dbCommand) > 0)

  result = true;

  return result;

  }

  [sql]

  ALTER PROCEDURE [dbo].[prc_IsUserInFavouriteList]

  (

  @UserNameIDint,

  @FavoriteUserNameIDint

  )

  AS

  BEGIN

  IF ((SELECT COUNT(*) FROM tbl_Favorites WHERE @UserNameID = UserNameID

  AND @FavoriteUserNameID = FavoriteUserNameID) <> 0)

  SELECT CAST ( 1 AS BIT)

  ELSE

  SELECT CAST( 0 AS BIT)

  END

  [/sql]

• tertiusdp

  SSCommitted

  Points: 1569

  More actions

  January 20, 2011 at 2:42 am

  #1275733

  This seems more of a programming query.

  If you use .net, see http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executenonquery.aspx

  for why it will return -1.