that's nice! well the app I'm trying to port under MONO/MySql is based on Linq to Sql. I don't use SqlMetal but the integrated Visual Studio 2008 Object Reletional Modeler; with this tool I can extract views from Sql Server and they work fine. So since SqlMetal and the visual Modeler are interchangeable I think that support views is really a good stuff. Thanks
On 13 Nov, 19:27, "Pascal Craponne" <[EMAIL PROTECTED]> wrote: > I should have taken a look at SqlMetal before: there is a /views switch > allowing to extract views, so I suggest we stick to this behaviour.I'll > commit Eugene's patch (posted a few minutes ago) with those changes. > > > > > > On Thu, Nov 13, 2008 at 18:56, Pascal Craponne <[EMAIL PROTECTED]> wrote: > > I don't have any mind about views, so this may change if someone is willing > > to support it, I'm OK with that.I don't know if SqlMetal supports views: > > - if SqlMetal does, then we can support them by default > > - if it doesn't, then we will need to add a command-line switch, to make > > the support optional > > > On Thu, Nov 13, 2008 at 18:18, oscar.peli <[EMAIL PROTECTED]> wrote: > > >> ok thanks > >> even if can I ask you to change your mind about Views? > >> In large projects (like the one I'm trying to port using Linq under > >> MySql/MONO/Linux) views are used a lot. > >> Thanks > > >> On 13 Nov, 18:00, "Pascal Craponne" <[EMAIL PROTECTED]> wrote: > >> > I don't know exactly how is it written for MySQL, but in a general way, > >> > views aren't supposed to be supported by DbMetal. > > >> > On Thu, Nov 13, 2008 at 17:57, oscar.peli <[EMAIL PROTECTED]> wrote: > > >> > > oh > >> > > but why I can find classes for every View in my DB? > >> > > This confused me a little. > > >> > > On 13 Nov, 17:54, "Pascal Craponne" <[EMAIL PROTECTED]> wrote: > >> > > > DbMetal doesn't extract views. > >> > > > If you want to use views, you will need to create your objects by > >> hand. > > >> > > > On Thu, Nov 13, 2008 at 17:49, oscar.peli <[EMAIL PROTECTED]> wrote: > > >> > > > > Hi, > >> > > > > this is what happens: > > >> > > > > I created a dummy View on MySql, named Prova, that returns all the > >> > > > > records of a table; > >> > > > > Then I run DbMetal and it gave me the Prova class; > >> > > > > In my code I wrote the following: > >> > > > > MyDC db = new MyDC(); > >> > > > > IQueryable<Prova> oProva = db.Prova; > >> > > > > What I'm expecting is a resultset with all the records of my Prova > >> > > > > table but it returns always an empy resultset. > > >> > > > > On 13 Nov, 16:31, "Pascal Craponne" <[EMAIL PROTECTED]> wrote: > >> > > > > > Hi, could you give more details? > > >> > > > > > On Thu, Nov 13, 2008 at 16:08, <[EMAIL PROTECTED]> wrote: > > >> > > > > > > Hello, I'm using dbLinq 0.18 and I've built with DbMetal a .cs > >> file > >> > > of > >> > > > > > > a MySql db, hosted on Linux. > >> > > > > > > My db is composed by some tables and some views. > >> > > > > > > Now I can interact with tables but if I query a view I get > >> always > >> > > an > >> > > > > > > empy set. > > >> > > > > > > There is an Issue on MySql Views? > >> > > > > > > Thanks > >> > > > > > > Oscar > > >> > > > > > -- > >> > > > > > Pascal. > > >> > > > > > jabber/gtalk: [EMAIL PROTECTED] > >> > > > > > msn: [EMAIL PROTECTED] > > >> > > > -- > >> > > > Pascal. > > >> > > > jabber/gtalk: [EMAIL PROTECTED] > >> > > > msn: [EMAIL PROTECTED] Nascondi testo citato > > >> > > > - Mostra testo citato - > > >> > -- > >> > Pascal. > > >> > jabber/gtalk: [EMAIL PROTECTED] > >> > msn: [EMAIL PROTECTED] Nascondi testo citato > > >> > - Mostra testo citato - > > > -- > > Pascal. > > > jabber/gtalk: [EMAIL PROTECTED] > > msn: [EMAIL PROTECTED] > > -- > Pascal. > > jabber/gtalk: [EMAIL PROTECTED] > msn: [EMAIL PROTECTED] Nascondi testo citato > > - Mostra testo citato - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/dblinq?hl=en -~----------~----~----~----~------~----~------~--~---
