DbLinq

Ok, so I guess the only way to do use DbLinq and allow dynamic queries at the same time requires: 1. Using "base.Connection.CreateCommand ()" to get a command object to perform a text query, then iterate over the results and copy into my custom dynamic tables - keeping in mind this is a db-specific query

Trying to avoid the use of ODBC. I use Linq mostly, but there are some cases where I need a more dynamic result. Is it possible to create an object of type "DynamicObject", pass it into "ExecuteQuery<TResult>()", and create the data members "on the fly" as they are queried (as "TryGetMember" is called)?

Better to use odbc connection

Ok, just found out about "DataContext.Connection.Create Command()" in one of the examples, is this the best way to approach this? I assume the only caveat is that I have to match the SQL to the provider/vendor type (obviously), since Linq helps to abstract it...?

Also, some of these tables are "options" tables, for drop downs, etc., and because there are a lot of them, I'm not exporting them to code, thus for the dynamically returned results, how would I get the schema of the returned results?

I have a report builder in a Silverlight client, and was wondering if anyone had an idea on how to use dynamic queries with DbLinq? I searched other discussions, but I'm not sure that the context of any involves what I'm asking. -jw

Please do not reply to this e-mail. We can be contacted at [email protected]. Trouble viewing this email? Click here <[link] 23> to view the online version. Please enable images for proper viewing.<[link]

sqlmetal doesn't like your tables. The relevant code is: var otherType = database.Tables.Single(t => t.Type.Name == association.Type).Type; var otherAssociation = otherType.Associations.Single( a => a.Type == table.Type.Name && a.ThisKey == association.OtherKey);

Hello, I have a MySQL database with a few tables which have indexes and identifying as well as non-identifying relationships established (i.e. primary and foreign keys, constraints). I also have about 20 tables in this database. I am trying to create the objects using sqlmetal on Ubuntu Linux. The

thanks for reply.. I was download source code and compiled it.. and in folder DbMetal I edit run_pgMetal.bat here is my code bin\DbMetal.exe /provider=PostgreSql /code=testCode.cs -user:postgres -database:testDatabase -server:localhost ... [More] -password:admin -sprocs Am I missed something? regards On Wed, Dec 8, 2010 at 11:03 AM, James Darbyshire <[email protected] [Less]