Inline...
On Thu, 2010-01-21 at 09:12 -0800, jbm417 wrote:
> I am converting a SqlServer application to use an embedded FireBird
> db. The original app uses linq which I would like to continue using.
...
> Have DbLinq in the VS 2008 c# based app but do not understand how to
> create a datacontext.
In theory, the same way you create a DataContext with Linq-to-SQL.
> For example:
>
> the original app has:
>
> private DataClasses1DataContext db_b = new
> DataClasses1DataContext();
How is the default constructor working? Don't you need a connection
string or something?.
> In the new app, using DbLinq, I am able to write:
>
> bConn = new FbConnection(ConStr);
> FirebirdDataContext fdb = new FirebirdDataContext(bConn);
>
> However, I cannot figure out where to go from here.
>
> Questions:
>
> 1. Can the DataClasses1 dbml be used or must I generate new dbml
> using DbMetal?
> Database structure, col names & types, are the same in both
> SqlServer & Firebird.
This command should work:
DbMetal /provider:Firebird /code:Entities.cs DataClasses1.dbml
This should create Entities.cs. If it doesn't, please let us know the
error that you see.
> 2. If new dbml is required, will a simple datacontext change in the
> query be sufficient?
I don't understand this question.
> Bottom line -- at the moment, I do not understand how
>
> FirebirdDataContext fdb = new FirebirdDataContext(bConn);
>
> provides any dbml association so that the query can find the geos
> table info.
Short answer: it doesn't, not directly.
The above DbMetal command will generate C# source code containing
entities based on the tables & columns from your .dbml file (just
as .NET SqlMetal does), and these generated types will provide the
information required to find the geos table info.
- Jon
--
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.
