Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using (var db = new BloggingContext())
- {
- // Create a SQL command to execute the sproc
- var cmd = db.Database.Connection.CreateCommand();
- cmd.CommandText = "[dbo].[uspCustomerAndCompanySearch] @Query";
- // Add Parameters to cmd here
- cmd.Parameters.Add(new SqlParameter("query", response.Query));
- try
- {
- ((IObjectContextAdapter)db).ObjectContext.Connection.Open()
- // Run the sproc
- var reader = cmd.ExecuteReader();
- // Read Blogs from the first result set
- var blogs = ((IObjectContextAdapter)db)
- .ObjectContext
- .Translate<Blog>(reader, "Blogs", MergeOption.AppendOnly);
- foreach (var item in blogs)
- {
- Console.WriteLine(item.Name);
- }
- // Move to second result set and read Posts
- reader.NextResult();
- var posts = ((IObjectContextAdapter)db)
- .ObjectContext
- .Translate<Post>(reader, "Posts", MergeOption.AppendOnly);
- foreach (var item in posts)
- {
- Console.WriteLine(item.Title);
- }
- }
- finally
- {
- ((IObjectContextAdapter)db).ObjectContext.Connection.Close();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement