In general, getting EF work with MySQL is a fairly simple task, that could be accomplished by downloading and installing ADO.NET driver for MySQL. But what concerns to me, it taken me about four hours to clarify some MySQL-specific details that affect generation of associations in Model Designer. Also after doing an experimentation with the code I realized that ADO.NET driver for MySQL, as well as other third party ADO.NET drivers, do not support “MARS” and, as far as I see, this significant restriction makes EF unusable with MySQL in large real-life projects. Please read below if you interested in more information on this questions.
(more…)
Tag Archives: virtuemart
Using ADO.NET Entity Framework with MySQL
Investigating VirtueMart 2.0 – part I
Recently I have started investigating VirtueMart 2.0.6. Below I recorded various issues that I have found along the way. Hopefully someone else (possibly myself down the line) will find these useful.
Configuring “Safe Path”
Create directory /home/test1/vmfiles:
mkdir /home/test1/vmfiles
Go to Configuration->Templates, enter the path:
![SNAGHTML215b44db[4]](https://developernote.com/wp-content/uploads/2012/05/SNAGHTML215b44db4.png "SNAGHTML215b44db[4]")
and press Save button.
How to modify product page title in VirtueMart 1.1.9, Joomla 1.5.23
Function $document->setTitle($title) is called from “administrator/components/com_virtuemart/classes/mainframe.class.php”:
function setPageTitle( $title ) {
global $mainframe;
$title = strip_tags(str_replace(' ',' ', $title));
$title = trim($title);
if( defined( '_VM_IS_BACKEND')) {
echo vmCommonHTML::scriptTag('', "//<![CDATA[
var vm_page_title=\"".str_replace('"', '\"', $title )."\";
try{ parent.document.title = vm_page_title; } catch(e) { document.title =vm_page_title; }
//]]>
");
}
elseif( vmIsJoomla('1.5') ) {
$document=& JFactory::getDocument();
$document->setTitle($title);
} else {
$mainframe->setPageTitle( $title );
}
}
Progressive discounts in VirtueMart
I did some investigation of VirtueMart 1.1.x discount system and the first thing I did notice is that VirtueMart 1.1.x does not support progressive discounts natively. In other words it does not allow to define the discount based on the amount of products bought or total amount of money paid.
