LinqToSql declare and instantiate DataContext best practice?

by

First, make sure you are disposing your DataContext when you’re done! He can be a heavy little bastard (edit not heavy to instantiate, but heavy to keep around if you keep using it without disposing); you don’t want old DataContexts hanging around in memory.

Second, the DataContext is intended to represent a single logical transaction. E.g. you should create a new one every time you want to start a new transaction, and get rid of it when that transaction is complete. So for your purposes, that is probably the scope of the GetUser method. If you have a series of DB calls that need to be made as a group, they should all use the same DC before getting rid of it.

More Related Contents:

  1. How to loop through all the properties of a class?
  2. Case insensitive string compare in LINQ-to-SQL
  3. Parse Delimited CSV in .NET
  4. Does XSLT have a Split() function?
  5. Is the Microsoft.VisualBasic namespace “true .NET” code?
  6. How do I get the MAX row with a GROUP BY in LINQ query?
  7. Pick unique Random numbers
  8. Update primary key value using entity framework
  9. Can I set Option Explicit and Option Strict on a Project/Solution level?
  10. Controlling Application’s Volume: By Process-ID
  11. Which is generally best to use — StringComparison.OrdinalIgnoreCase or StringComparison.InvariantCultureIgnoreCase?
  12. Is it necessary to add a @ in front of an SqlParameter name?
  13. Accessing imgUr thru OAuth (uploading to user account)
  14. Making DataGridView rows a certain color based on a column value
  15. How do I validate email address formatting with the .NET Framework?
  16. Does this code prevent SQL injection?
  17. Option Strict On and .NET for VB6 programmers
  18. RestSharp serialization to JSON, object is not using SerializeAs attribute as expected
  19. How should I cast in VB.NET?
  20. How to print datagridview table with its header in vb.net?
  21. How to use “contains” or “like” in a dynamic linq query?
  22. How to convert date format in vb.net?
  23. What can I do to resolve a “Row not found or changed” Exception in LINQ to SQL on a SQL Server Compact Edition Database?
  24. Determine if a generic param is a Nullable type
  25. Get the name of Enum value
  26. Assigning a value to ComboBox Items
  27. Is there a way to define an implicit conversion operator in VB.NET?
  28. String manipulation with & or + in VB.NET
  29. Do you think it’s advantageous to switch to Entity Framework? [closed]
  30. ‘Shadows’ vs. ‘Overrides’ in VB.NET

Leave a Comment