I need an embedded database for one of our .net applications.
This database should support sql (Unlike Berkley).
Can anyone suggest any options.
The major options I can think of are:
I'm writing a LINQ to SQL statement, and I'm after the standard syntax for a normal inner join with an ON clause in C#. How do you represent the following in LINQ to SQL: select DealerContact.* from Dealer inner join …
How can I insert datetime into the SQL Database table ? Is there a way to insert this query through the insert command in C# / .NET?
I've read a lot of posts about inserting a DataTable into a SQL table, but is there an easy way to pull a SQL table into a .NET DataTable?