code_junkie

SQL custom functions in Enterprise Library

Nov 12th, 2011
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. Database db = DatabaseFactory.CreateDatabase("ConnectionString");
  2. DbCommand cmd = db.GetStoredProcCommand("FunctionName");
  3. db.AddInParameter(cmd, "Value1", DbType.String, Param1Value);
  4. db.AddInParameter(cmd, "Value2", DbType.String, Param2Value);
  5. return Convert.ToBoolean(db.ExecuteScalar(cmd));
  6.  
  7. SELECT FuncName(@Param1)
  8.  
  9. SELECT * FROM FuncName(@Param1)
Add Comment
Please, Sign In to add comment