What is the solubility of methylphenidate in both ethanol and H2O?
The solubility of methylphenidate in both ethanol and water can vary depending on various factors such as temperature, pressure, and pH.

At room temperature (25°C), methylphenidate hydrochloride has a solubility of about 15 mg/mL in water and about 100 mg/mL in ethanol. However, it is important to note that these solubility values are for the hydrochloride salt form of methylphenidate and may differ for other forms.

Additionally, the solubility of methylphenidate can also depend on the pH of the solution. For example, methylphenidate is more soluble in acidic solutions than in basic ones.

It is always important to consult a reliable source for the most accurate and up-to-date information on the solubility of specific substances in different solvents.
What would be the purpose of dissolving methylphenidate in water? Isn't it normally taken as a pill?
It is true that methylphenidate is typically taken as a pill, but there are still several reasons you may want to dissolve it in water. A common reason someone would dissolve a methylphenidate in water is to allow the drug to be administered intravenously at a hospital or other care facility. Dissolving the drug in water can also make it easier for those who very young or very old to ingest as opposed to a pill which could be choked on. 

In my previous answer, I was only referring to the pure form of methylphenidate hydrochloride, not methylphenidate in it's prescription or over the counter form. As you mentioned, this medicine is typically taken in pill form, which are often crafted to slowly release the drug dosage. Dissolving one of these pills in water could result in improper dosage if this is the case and would be considered off label usage. Please consult a medical professional before attempting to dissolve medication like methamphetamine in water.
Can you describe the best, quickest and safest method to cook this drug?