Silverlight Beta3 + MySql + Linq

05-26-2009 9:09 AM |

Hello,

We have to develop our Project with the combination of Silverlight Beta3 + MySql + Linq but we are not able to get any resource for Mysql with linq.

We tried using DbLinq-0.18 but 

Is someone already working on this or give us some suggestions ??

Please help us.

Thanks in advance.

Re: Silverlight Beta3 + MySql + Linq

05-26-2009 9:51 AM |

I'm using SL2 with MySQL and PHP.

You don't really need linq, but if you want to you can return the data via PHP, put it into a dataset and use linq to dataset or return it as XML and use link to XML.

 

Tom

Re: Silverlight Beta3 + MySql + Linq

05-26-2009 10:03 AM |

Thanks for the reply. I am using ASP.NET 2008 C#. Initially our Project was in Silverlight2 + SQL Server 2005 + Linq + ASP.NET 200 C#.

Now we have to use Mysql instead of SQL Server.

Can you please help me with some tutorials for the same ?

Thanks again.

Re: Silverlight Beta3 + MySql + Linq

05-26-2009 11:02 AM |

There is a working example here:

http://slphpbackend.codeplex.com/

A tutorial here:

http://www.bestechvideos.com/2007/06/26/silverlight-delivering-parameterized-silverlight-content-with-php

Tom

 

Re: Silverlight Beta3 + MySql + Linq

05-27-2009 5:18 AM |

Thank a lot. Can you provide us some information about .NET instead of PHP.

Thank you so much.

Re: Silverlight Beta3 + MySql + Linq

05-27-2009 2:11 PM |

Thank you so much Tom. I have one question not related to Silverlight but related to mysql stored procedure.

I have to insert data in 2 tables which has one to many relationship. If I insert one record in first table then whatever ID it generates I want to insert multiple records with the same ID in 2nd table. How do I pass this to stored procedure. Like SQL Server we can pass XML document and parse it and insert accordingly.

Can you please suggest me how to do this, it will be really very helpful.

If possible please share your personal mail id also so that I can take help of your for mysql.

Thanks again.

Re: Silverlight Beta3 + MySql + Linq

05-27-2009 3:53 PM |

I don't use stored procedures, I use SQL query strings that I create dynamicaly in PHP.  A similar approach should work in .NET.

I do something similar to what you are asking about.  I create the query string to look up the ID in one table and then use the ID to create the query string to look in another table.

I'm not a MySQL nor a database expert.  I learned enough about MySQL to write what I needed by searching on the web for examples and tutorials.

 

Tom

 

Re: Silverlight Beta3 + MySql + Linq

05-28-2009 2:38 AM |

Thanks for the reply. Actually what I asked you I have searched on google and some of the forums but till now I have not got any reply. So thought of asking you as you are working on MySql. I am completely new to MySql. Thanks again.

Re: Re: Silverlight Beta3 + MySql + Linq

07-10-2009 1:14 AM |

 I have encountered the same problem.

Re: Re: Silverlight Beta3 + MySql + Linq

07-10-2009 1:16 AM |

 I have encountered the same problem.

The links provided by Tom actually descride the usage of MySql with ASP.NET via Ado.Net.

But what i need is how do we use Linq with MySql , change the dbml file that's in the silverlight project.

 

Re: Silverlight Beta3 + MySql + Linq

07-20-2009 9:27 AM |

 

Why not use alinq -- The Best Database Linq Proivder, it supports access, sqlite, mysql , oracle and firebird database . but the importan is alinq very easy to use , because of the API of ALinq is same with DLinq.  All DLinq knowledge and existing DLinq documentation is therefore directly applicable to ALinq.

more information about ALinq , please visit http://www.alinq.org

Re: Re: Silverlight Beta3 + MySql + Linq

07-20-2009 9:42 AM |

The only problem is there is a learning curve for aLinq again.