Persist Data by Programming Against Interface

Your repository should accept BankAccount – not IBankAccount because Linq-to-sql doesn’t know what is IBankAccount and compiler doesn’t allow you to store it without casting it first to BankAccount (that can obviously fail at runtime if IBankAccount instance is not a BankAccount).

Once you have BankAccount you simply call:

Context.BankAccounts.Add(account);
Context.SubmitChanges();

Related Contents:

  1. Polymorphism: Is ORM entity a Domain Entity or Data Entity?
  2. Making Entity Class Closed for Changes
  3. Get all associate/composite objects inside an object (in Abstract way)
  4. Returning IEnumerable vs. IQueryable
  5. Difference Between Select and SelectMany
  6. EF codefirst : Should I initialize navigation properties?
  7. What is the syntax for an inner join in LINQ to SQL?
  8. LINQ – Left Join, Group By, and Count
  9. How can I conditionally apply a Linq operator?
  10. LINQ to SQL – Left Outer Join with multiple join conditions
  11. NHibernate QueryOver with Fetch resulting multiple sql queries and db hits
  12. To return IQueryable or not return IQueryable [closed]
  13. Understanding .AsEnumerable() in LINQ to SQL
  14. C# “internal” access modifier when doing unit testing
  15. TransactionScope vs Transaction in LINQ to SQL
  16. How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
  17. LINQ: combining join and group by
  18. LINQ Expression to return Property value?
  19. Compare nullable types in Linq to Sql
  20. LINQ to SQL: Multiple joins ON multiple Columns. Is this possible?
  21. Max or Default?
  22. Accessing properties through Generic type parameter
  23. Convert Linq Query Result to Dictionary
  24. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  25. How do you perform a CROSS JOIN with LINQ to SQL?
  26. LINQ Where Ignore Accentuation and Case
  27. Updating an ObservableCollection in a separate thread
  28. Minimal and correct way to map one-to-many with NHibernate
  29. A dependent property in a ReferentialConstraint is mapped to a store-generated column
  30. How to make LINQ execute a (SQL) LIKE range search
  31. Refactoring code to avoid anti-pattern
  32. Identifying NHibernate proxy classes
  33. Using contains() in LINQ to SQL
  34. Should I abstract the validation framework from Domain layer?
  35. LINQ and pagination [duplicate]
  36. LINQ to SQL Where Clause Optional Criteria
  37. ‘CompanyName.Foo’ is a ‘namespace’ but is used like a ‘type’
  38. C# – Asserting two objects are equal in unit tests
  39. MVVM: Binding to Model while keeping Model in sync with a server version
  40. Multiple Aggregates / Repositories in one Transaction
  41. NHibernate How do I query against an IList property?
  42. How to implement batch fetching with Fluent NHibernate when working with Oracle?
  43. NHibernate – Many to Many Query using Junction/Joiner Table
  44. Custom Method in LINQ to SQL query
  45. How to create NHibernate HasManyToMany relation
  46. NUnit Test Run Order
  47. Get sum of two columns in one LINQ query
  48. Best way to update LINQ to SQL classes after database schema change
  49. Best way to save a ordered List to the Database while keeping the ordering
  50. Last and LastOrDefault not supported

Leave a Comment