Would you like to go to Canada with David and me?

Take “David” out: Would you like to go to Canada with me?

See?

And I was always taught hat the other person being referred to comes before you talk about yourself in such cases. Why, I don’t know.

“With me” is correct. The pronoun “I” is used as the subject in a clause, the corresponding pronoun “me” is used as a direct object or, as here, object of preposition (here the preposition is “with”). Social deference may make the order “David and me” preferable to “me and David.”

We were always taught David and I when I was at school.

It is ‘David and me’, for the reasons @aprilsimnel and @ichthus so beautifully stated.

Just a reminder, prepositions are words like: to, for, from, above, below, between, around. So when it is the part of the sentence following the preposition you use me, and you always put yourself last.

If you took Spanish in school by chance, you probably had to conjugate verbs, and might remember, when the singular is I then the plural is we, and when the singular is me the plural is us. So when us sounds right in the sentence, you use me. Would you like to go to Canada with us? Would you like to go to Canada with David and me. Janet stood between us. Janet stood between Sean and me. Foreign language helped me learn a lot of rules in English.

well I guess that answers my question, turns out I was wrong, thanks everyone. =]

The problem is a phenomenon called “hypercorrection”. People so often mistakenly say “David and me are going to the store” and get corrected for it that they come to believe that “I” is used in all cases, even though that is not true. “Me” is used as a direct object, indirect object, and object of a preposition.

Give David and me the phone. (Indirect object)
He chastised David and me. (Direct object)
Please come with David and me. (Object of preposition)

“I” is used as a subject; that’s it:

David and I are going to the store (Subject).

I was taught to say “David and I”

Try using only one pronoun. He went to the store with I. That sounds very odd and is, indeed, incorrect, just as “Me went to the store” is wrong.

I am sad that people here have learned the wrong usage at school. It is disheartening for me, you and everyone else.

It was disheartening for David and me.

Rephrase the sentence with just yourself. If you would say “I” in that sentence then you would say “David and I”. For instance… “David and I are going to town” would be correct. and “Alice is going to town with me and David” is also correct.

http://www-csli.stanford.edu/~zwicky/Grano.finalthesis.pdf
http://linguistlist.org/issues/18/18-2380.html

@OreetCocker @Mom2BDec2010 No you weren’t. You were taught to say “David and I” as the subject of a sentence, and “David and me” as the object. You might have learned to always say “David and I”, but I guarantee that’s not what you were taught.

@DominicX Very well said.

@DominicX I’m not convinced that hypercorrection is to blame. Object-position “X and I” has been around since the 17th century, which predates (I think) English being taught in schools.

It is neither. The correct answer has already been given.

I am going to the store.
David and I are going to the store.

Would you like to go to the store with me?
Would you like to go to the store with David and me?

If David and I are objects of a proposition, it is David and me.

If they are the subject, it is David and I…David and I would like to go to Canada…

@Ben_Dover (Might you mean “preposition”?)

And if you use the verb “to be,” and you are feeling pedantic, you’d say:

“It is I,”

“It is ‘David and me.’ ”

@gailcalled I was hoping to get propositioned…

David and me