As you all know, Subsonic 3 already released several months ago. Until now, team already released 3 minor version of Subsonic 3, so current version is Subsonic 3.0.3.
Unlike previous version, Subsonic 3 implements full LINQ provider which support only by .NET Framework 3.5. Thats why, Subsonic 3 only supported by .NET Framework 3.5 above.
Although it’s already released up to 3 minor version, there are several very annoying bugs. One of them is Subsonic 3 doesn’t support if column name in database doesn’t match with property name.
For this, I use following table script with MySQL database server
[sourcecode language="SQL"]CREATE TABLE `product_test` (
`product_test_id` int(11) NOT NULL AUTO_INCREMENT,
`product_name` varchar(45) NOT NULL,
`product_date` datetime NOT NULL,
PRIMARY KEY (`product_test_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; [/sourcecode]
The SQL Statement that I’ve got when I’m trying to query using Subsonic is like this
SELECT NULL
FROM `product_test` AS t0
LIMIT 0,1
And the code is like this
var firstProductTest = productTestAll.FirstOrDefault();
Assert.AreEqual(1, firstProductTest.ProductTestId);
Assert.AreEqual(“PAMPERS”, firstProductTest.ProductName);
But if I tried to get records from product_test using, it only gives me 0 records, weird….
Share on Facebook
Recent Comments