On Apr 19, 2:06 pm, [email protected] wrote:
> I'll create a new database with a singl e column and single table just
> to make sure it's not something with my database schema.
>
I created a database with a single table.
create table customers
(
id varchar(36) not null,
username varchar(36) not null,
Primary Key(id)
);
Using DBLinq I can insert records no problem but when running the Linq
query below and any other one I tried I was still not getting a where
clause on the SQL sent to the database. I thought maybe it was
something in System.Data.Linq that could have changed with .Net 3.5
SP1 so I tried using the System.Data.Linq assembly that was on the
DBLinq svn but the same thing occurred.
DbLinqDB db = new DbLinqDB(new NpgsqlConnection
("Database=dblinq;Host=localhost;User
Id=postgres;Password=password"));
db.Log = Console.Out;
var customers = from customer in db.Customers
where customer.UserName == "test"
select customer;
foreach (var customer in customers) {
Console.WriteLine(customer.ID + " " + customer.UserName);
}
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
