Advertisement
Guest User

Untitled

a guest
May 31st, 2016
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. UserActivity log = new UserActivity();
  2.  
  3. ApplicationDbContext db = new ApplicationDbContext();
  4.  
  5. log.UserEmail = User.Identity.Name;
  6. log.SQL_Query = queryString;
  7. log.Query_Start = String.Format("{0:hh:mm:ss}", start);
  8. log.Query_End = String.Format("{0:hh:mm:ss}", end);
  9. log.Query_Time = String.Format("{0:mm:ss.ff}", Duration.ToString());
  10.  
  11. db.UserActivities.Add(log);
  12.  
  13. db.SaveChanges();
  14.  
  15. CREATE TABLE [dbo].[UserActivities] (
  16. [Id] INT NOT NULL,
  17. [UserEmail] VARCHAR (255) NOT NULL,
  18. [SQL_Query ] VARCHAR (1000) NOT NULL,
  19. [Query_Start] VARCHAR (11) NULL,
  20. [Query_End] VARCHAR (11) NULL,
  21. [Query_Time] VARCHAR (11) NULL,
  22. [Error_Message] VARCHAR (255) NULL,
  23. PRIMARY KEY CLUSTERED ([Id] ASC)
  24. );
  25.  
  26. log.UserEmail.Length;
  27. 21
  28. log.Query_End.Length;
  29. 8
  30. log.Query_Start.Length;
  31. 8
  32. log.SQL_Query.Length;
  33. 32
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement