Search code examples
sql-server-2005stored-proceduresstrongly-typed-dataset

typed-Dataset VS Own access Database classes


Hi i would like to know if it's better to use typed-dataset rather than Own access with Datareader and Store procedure?


Solution

  • Typed Datasets are alwaya a better option compared to using plain DataReaders.

    Typed datasets gets you,

    • abstraction over SQL queries and StoredProcedures and you call them by making function calls.
    • freedom from managing connection-strings
    • typed rerpresentation of each table which adds a great deal for type-safety at compile-time.
    • and much more..