|
| | | StrataFrame Beginner
 
Group: StrataFrame Users
Last Login: 08/13/2008 8:31:01 AM
Posts: 16, Visits: 663 |
| | I was wondering if anybody has used CoreLabs MySql control with StrataFrame. Mike |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 4:58:13 AM
Posts: 4,379, Visits: 4,421 |
| | At present we do not have a MySQL provider out of the box...however, this is actually a provider that we have been considering adding to the framework. Ironically there is very little demand for MySQL since SQL Server 2005 Express was released. Though this is still on our slate of potential providers to add to the framework out of the box. Most developers going with SQL Server since it is generally a bit more stable and has better overall performance...but I know that there are still some web people out there that like to use MySQL. |
| |
| | | StrataFrame Beginner
Group: StrataFrame Users
Last Login: 08/13/2008 8:31:01 AM
Posts: 16, Visits: 663 |
| | Hi Trent I would like to convert one of our projects using MySql over to StrataFrame. What file would I need to modify. Also the next question is. Will the StrataFrame Business Mapper work the same way as for the MS SQL. Just as a note the Core MySQL .net control works extremly well, and fast. As you said for web, mysql is cheaper with the host providers. |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 4:58:13 AM
Posts: 4,379, Visits: 4,421 |
| What file would I need to modify. This is not a quick answer really. You would need to create a DataSourceItem that inherits from the DbDataSourceItem class. The best thing would be to copy over the SqlDataSourceItem and start from there. That would be the closest data source to MySQL. Then you will just have to start tweaking it until it is ready for MySQL. Will the StrataFrame Business Mapper work the same way as for the MS SQL. No. You would have to connect using the OLEDB provider for the time being, which by the way, is also a way to talk to MySQL right now without creating a custom data source item. Adding the native implementation into the BO Mapper like the DDT, SQL Server, Oracle, and DB2 will require a change by us to make this work. Like I said before, I think that it is likely that we will create a MySql data source item, but I cannot give you an exact date of when this will happen. |
| |
| | | StrataFrame User
Group: StrataFrame Users
Last Login: 09/05/2008 2:26:32 AM
Posts: 413, Visits: 1,565 |
| hi,
Any update on mySQL datasourceitem?
Thank you |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 4:58:13 AM
Posts: 4,379, Visits: 4,421 |
| | Not yet...there is such little demand a number of other items are higher up on the list (i.e. DDT enhancements, new BO Mapper and BO Mapper enhancments, etc.). We will still more than likely create one but to be honest, there are fewer and fewer demands (which were small to begin with) for MySQL. I think that many developers have moved over to SQL Server Express. However, we know that there are still developers who want to use MySQL and still have this on our list. |
| |
|
|