Advertisement
Guest User

Untitled

a guest
Jun 26th, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.19 KB | None | 0 0
  1. using (var db = new BloggingContext())
  2. {
  3.  
  4. // Create a SQL command to execute the sproc
  5. var cmd = db.Database.Connection.CreateCommand();
  6. cmd.CommandText = "[dbo].[uspCustomerAndCompanySearch] @Query";
  7. // Add Parameters to cmd here
  8. cmd.Parameters.Add(new SqlParameter("query", response.Query));
  9.  
  10. try
  11. {
  12.  
  13. ((IObjectContextAdapter)db).ObjectContext.Connection.Open()
  14. // Run the sproc
  15. var reader = cmd.ExecuteReader();
  16.  
  17. // Read Blogs from the first result set
  18. var blogs = ((IObjectContextAdapter)db)
  19. .ObjectContext
  20. .Translate<Blog>(reader, "Blogs", MergeOption.AppendOnly);
  21.  
  22.  
  23. foreach (var item in blogs)
  24. {
  25. Console.WriteLine(item.Name);
  26. }
  27.  
  28. // Move to second result set and read Posts
  29. reader.NextResult();
  30. var posts = ((IObjectContextAdapter)db)
  31. .ObjectContext
  32. .Translate<Post>(reader, "Posts", MergeOption.AppendOnly);
  33.  
  34.  
  35. foreach (var item in posts)
  36. {
  37. Console.WriteLine(item.Title);
  38. }
  39. }
  40. finally
  41. {
  42. ((IObjectContextAdapter)db).ObjectContext.Connection.Close();
  43. }
  44. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement