Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Other Discussions
  3. The Weird and The Wonderful
  4. Another ancient oddity in .net

Another ancient oddity in .net

Scheduled Pinned Locked Moved The Weird and The Wonderful
csharpquestion
18 Posts 9 Posters 13 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • P Offline
    P Offline
    PIEBALDconsult
    wrote on last edited by
    #1

    A Row may be a record, but a (logical) Record may comprise several Rows across several tables. It's like atoms (rows) and molecules (records). So, DataTables use DataRows, excellent. System.Data.DataRow System.Data.DataRowView System.Data.DataTable.Rows System.Data.DataTable.NewRow System.Data.DataView.RowFilter But why, then, is a System.Data.IDataReader a System.Data.IDataRecord ? Which is illogical. Why not System.Data.IDataRow ?

    H B T O L 5 Replies Last reply
    0
    • P PIEBALDconsult

      A Row may be a record, but a (logical) Record may comprise several Rows across several tables. It's like atoms (rows) and molecules (records). So, DataTables use DataRows, excellent. System.Data.DataRow System.Data.DataRowView System.Data.DataTable.Rows System.Data.DataTable.NewRow System.Data.DataView.RowFilter But why, then, is a System.Data.IDataReader a System.Data.IDataRecord ? Which is illogical. Why not System.Data.IDataRow ?

      H Offline
      H Offline
      honey the codewitch
      wrote on last edited by
      #2

      It has been a long time since I've touched that corner of .NET but I seem to remember that the IDataRow exists somewhere and has things like events on it or otherwise at least things that IDataRecord can't do, and maybe, if memory serves, IDataRecord accesses things closer to the metal (using raw DB types and such) than IDataRow.

      To err is human. Fortune favors the monsters.

      1 Reply Last reply
      0
      • P PIEBALDconsult

        A Row may be a record, but a (logical) Record may comprise several Rows across several tables. It's like atoms (rows) and molecules (records). So, DataTables use DataRows, excellent. System.Data.DataRow System.Data.DataRowView System.Data.DataTable.Rows System.Data.DataTable.NewRow System.Data.DataView.RowFilter But why, then, is a System.Data.IDataReader a System.Data.IDataRecord ? Which is illogical. Why not System.Data.IDataRow ?

        B Offline
        B Offline
        BillWoodruff
        wrote on last edited by
        #3

        imho such "genomic duplication" reflects the bumpy evolution of so-called "computer languages," as language implementers seek to broaden usage by incorporating familiar semantics ... at the cost of semantic consistency. imho, "Where" in Linq is a good example: what it actually does is select; while Linq "Select" really means transform. But, those semantic choices were consistent with what SQL users were familiar with. If you disagree, please enlighten me: I never had any depth experience with SQL. cheers, Bill

        «The mind is not a vessel to be filled but a fire to be kindled» Plutarch

        1 Reply Last reply
        0
        • P PIEBALDconsult

          A Row may be a record, but a (logical) Record may comprise several Rows across several tables. It's like atoms (rows) and molecules (records). So, DataTables use DataRows, excellent. System.Data.DataRow System.Data.DataRowView System.Data.DataTable.Rows System.Data.DataTable.NewRow System.Data.DataView.RowFilter But why, then, is a System.Data.IDataReader a System.Data.IDataRecord ? Which is illogical. Why not System.Data.IDataRow ?

          T Offline
          T Offline
          Thornik
          wrote on last edited by
          #4

          Don't ask MS "why you give this name?" :) MS always fail here (like naming responsibility were given to mexican hobo). Add here that .NET itself is a "renamed Java" with appropriate legacy. And only years later MS made .NET "as it should be", but legacy classes still here. That's why we have Array completely incompatible with simple List<>. Don't ask, just ignore. :)

          F 1 Reply Last reply
          0
          • P PIEBALDconsult

            A Row may be a record, but a (logical) Record may comprise several Rows across several tables. It's like atoms (rows) and molecules (records). So, DataTables use DataRows, excellent. System.Data.DataRow System.Data.DataRowView System.Data.DataTable.Rows System.Data.DataTable.NewRow System.Data.DataView.RowFilter But why, then, is a System.Data.IDataReader a System.Data.IDataRecord ? Which is illogical. Why not System.Data.IDataRow ?

            O Offline
            O Offline
            obermd
            wrote on last edited by
            #5

            DataRows are related to the tabular nature of a DataGridView and don't have to be backed by a database. DataRecords are related to actual database records.

            P 1 Reply Last reply
            0
            • O obermd

              DataRows are related to the tabular nature of a DataGridView and don't have to be backed by a database. DataRecords are related to actual database records.

              P Offline
              P Offline
              PIEBALDconsult
              wrote on last edited by
              #6

              obermd wrote:

              DataRecords are related to actual database records.

              Not necessarily.

              1 Reply Last reply
              0
              • T Thornik

                Don't ask MS "why you give this name?" :) MS always fail here (like naming responsibility were given to mexican hobo). Add here that .NET itself is a "renamed Java" with appropriate legacy. And only years later MS made .NET "as it should be", but legacy classes still here. That's why we have Array completely incompatible with simple List<>. Don't ask, just ignore. :)

                F Offline
                F Offline
                F Margueirat
                wrote on last edited by
                #7

                This could have been answer without naming any nationality.

                T 1 Reply Last reply
                0
                • F F Margueirat

                  This could have been answer without naming any nationality.

                  T Offline
                  T Offline
                  Thornik
                  wrote on last edited by
                  #8

                  Why not? Or you SCARED to say anything w/o government approval? Sorry, but I don't play this "tolerant games".

                  F 1 Reply Last reply
                  0
                  • T Thornik

                    Why not? Or you SCARED to say anything w/o government approval? Sorry, but I don't play this "tolerant games".

                    F Offline
                    F Offline
                    F Margueirat
                    wrote on last edited by
                    #9

                    I'm lucky to live in a country where I can say pretty much what I want without the government coming after me. I'm also lucky enough to be in a position where I don't need to diminish anyone to feel that I'm better.

                    T 1 Reply Last reply
                    0
                    • F F Margueirat

                      I'm lucky to live in a country where I can say pretty much what I want without the government coming after me. I'm also lucky enough to be in a position where I don't need to diminish anyone to feel that I'm better.

                      T Offline
                      T Offline
                      Thornik
                      wrote on last edited by
                      #10

                      Very right now you try to diminish me to feel higher than me. Because by some reason you think I offended somebody. Elaborate HOW, please??

                      M D F 3 Replies Last reply
                      0
                      • P PIEBALDconsult

                        A Row may be a record, but a (logical) Record may comprise several Rows across several tables. It's like atoms (rows) and molecules (records). So, DataTables use DataRows, excellent. System.Data.DataRow System.Data.DataRowView System.Data.DataTable.Rows System.Data.DataTable.NewRow System.Data.DataView.RowFilter But why, then, is a System.Data.IDataReader a System.Data.IDataRecord ? Which is illogical. Why not System.Data.IDataRow ?

                        L Offline
                        L Offline
                        Lost User
                        wrote on last edited by
                        #11

                        A DataReader is "forward reading" only. "Rows" have never been part of the nomenclature associated with sequential data sets (i.e. records; record set). Rows can be usually be [indexed]; "records" rarely, unless they're fixed length (it's usually a positioning; then a read). DataReader.HasRows throws it all out the window; of course.

                        "Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I

                        1 Reply Last reply
                        0
                        • T Thornik

                          Very right now you try to diminish me to feel higher than me. Because by some reason you think I offended somebody. Elaborate HOW, please??

                          M Offline
                          M Offline
                          Member_5893260
                          wrote on last edited by
                          #12

                          Nobody needs to try to diminish you. Your ability to write in English (or, really, the lack thereof) does that quite happily, all by itself.

                          T 1 Reply Last reply
                          0
                          • T Thornik

                            Very right now you try to diminish me to feel higher than me. Because by some reason you think I offended somebody. Elaborate HOW, please??

                            D Offline
                            D Offline
                            Dave DD
                            wrote on last edited by
                            #13

                            Well you've potentially offended hobos, Mexican's, and Mexican hobos. As a hobo myself I am very offended.

                            T 1 Reply Last reply
                            0
                            • M Member_5893260

                              Nobody needs to try to diminish you. Your ability to write in English (or, really, the lack thereof) does that quite happily, all by itself.

                              T Offline
                              T Offline
                              Thornik
                              wrote on last edited by
                              #14

                              Your reply is just proof you're dumb young sh.... who tries to diminish people just to feel better (because in reality you're nothing). English is my SECONDARY language and as a secondary it's more than good. But main point is you're so miserable that knowing nothing about me all you could say is "your english is bad". Yep, I know! When pathetic people try to offend me, they use my English level. :) Enough said, dumb! You're not interesting anymore, get lost.

                              M 1 Reply Last reply
                              0
                              • D Dave DD

                                Well you've potentially offended hobos, Mexican's, and Mexican hobos. As a hobo myself I am very offended.

                                T Offline
                                T Offline
                                Thornik
                                wrote on last edited by
                                #15

                                As a monkey who permanently offended on everything, you need some help - suck smth for example.

                                D 1 Reply Last reply
                                0
                                • T Thornik

                                  Your reply is just proof you're dumb young sh.... who tries to diminish people just to feel better (because in reality you're nothing). English is my SECONDARY language and as a secondary it's more than good. But main point is you're so miserable that knowing nothing about me all you could say is "your english is bad". Yep, I know! When pathetic people try to offend me, they use my English level. :) Enough said, dumb! You're not interesting anymore, get lost.

                                  M Offline
                                  M Offline
                                  Member_5893260
                                  wrote on last edited by
                                  #16

                                  Oh well. Thanks for calling me young, though. At 56, having been programming for 43 years, I find it quite invigorating when idiots make assumptions. But at least you've got proof.

                                  1 Reply Last reply
                                  0
                                  • T Thornik

                                    As a monkey who permanently offended on everything, you need some help - suck smth for example.

                                    D Offline
                                    D Offline
                                    Dave DD
                                    wrote on last edited by
                                    #17

                                    Stay classy

                                    1 Reply Last reply
                                    0
                                    • T Thornik

                                      Very right now you try to diminish me to feel higher than me. Because by some reason you think I offended somebody. Elaborate HOW, please??

                                      F Offline
                                      F Offline
                                      F Margueirat
                                      wrote on last edited by
                                      #18

                                      You really need some mental gymnastic to read my message and think that I'm trying to diminish you. I am not the one inserting some nationality (Mexican in your case) followed by a derogatory term (hobo) to say something is bad. I was not offended, I just said that the message could have been answered without inserting any nationality. I don't get offended by random people on Internet, I would be a very bitter person if I did. But I also tend to think that bigots are usually not the smartest people in the planet. That being said, I'm not interested in wasting more time responding to someone that is showing your kind of behaviour, I have better things to do with my life. Hasta la vista Thornik.

                                      1 Reply Last reply
                                      0
                                      Reply
                                      • Reply as topic
                                      Log in to reply
                                      • Oldest to Newest
                                      • Newest to Oldest
                                      • Most Votes


                                      • Login

                                      • Don't have an account? Register

                                      • Login or register to search.
                                      • First post
                                        Last post
                                      0
                                      • Categories
                                      • Recent
                                      • Tags
                                      • Popular
                                      • World
                                      • Users
                                      • Groups