This project has moved. For the latest updates, please go here.

Can you query BrightStarDB from LinqPad

Jan 28, 2014 at 11:02 PM
Hi,

Is there anyway to query BrightStarDB from LinqPad? (http://www.linqpad.net/)

Any ideas?

Thanks

Mike
Jan 29, 2014 at 7:11 AM
 Why does LINQPad use LINQ to SQL under the covers, rather than Entity Framework?

LINQ to SQL is faster with large schemas and in most cases, emits better SQL. You can, however, use EF with EDMs that you define yourself. For querying SQLite, MySQL and Oracle (via the optional plug-in), LINQPad uses Matt Warren's IQueryable toolkit.
It seems to me that the tool uses some linq api to generate sql and also is designed to work with a relational db (from the main picture). Bsdb linq api creates sparql, so in short i don't think it's possible.
Jan 29, 2014 at 9:17 AM
Sure, it can do SQL but there are lots of extensibility providers for querying other data sources. There is one for RavenDB (just as an example of a NoSQL provider).

Entity framework is supported I believe (see here http://oreilly.com/pub/e/1295)

but you can write your own using their Data Context extensibility model (http://www.linqpad.net/extensibility.aspx).

I was just wondering if anyone had looked at this - I've only just started playing with BrightStarDB so not in a position to look at this although might do once I'm more familiar with it.

I think it's worth it as LinqPad is such an invaluable tool and it's a good way to expose more people to BrightStarDB - Just my opinion!

Thanks

Mike