Insight.Database lets you call your database with almost no code, and makes it easy to send objects to your database and get them back. It's available under MS Public License.
Links
Questions tagged [insight.database]
26 questions
0
votes
0 answers
Passing multiple Table-Value parameters to stored procedure
I am trying to insert multiple records into multiple tables using one call to a stored procedure which then calls into the corresponding stored procedures that insert into the individual tables.
I am using Insight.Database which has the option to…
Kassem
- 8,116
- 17
- 75
- 116
0
votes
1 answer
Add a parameter to an existing Func
It's a bit tricky question and I don't know if it's possible.
Let's say that I have a class Foo1 that's in a DLL and I can't modify it. The class looks like this:
public class Foo1 : IFoo
{
public Foo1(Func postRead);
}
I…
billybob
- 2,859
- 6
- 35
- 55
0
votes
1 answer
INSERT statement not working using Insight.Database with Oracle
I am using Insight.Database for Oracle. I am trying to get an insert statement to work but keeps failing with an "ORA-00936: missing expression" exception. Here is the code I am trying to execute:
var myQuery =
@"insert into MySchema.MyTable…
user3081814
- 141
- 1
- 1
- 11
0
votes
1 answer
Insight.Database procedure call using ODBC fails
I am using Insight.Database in C# via the ODBC provider to connect to a iSeries DB2 database. There is a stored proc in db2 called InsertBeer. All the following calls work great!:
List beers = conn.QuerySql("SELECT * FROM Beer WHERE…
Impostor Syndrome
- 357
- 3
- 14
0
votes
1 answer
Insight.Database One to Many Mapping from a JOIN using Auto Interface
Insight.Database supports mapping One to Many results if the SQL has multiple SELECT statements, one for Parent and the for the children. See: https://github.com/jonwagner/Insight.Database/wiki/Specifying-Result-Structures
CREATE PROC…
dannie.f
- 2,395
- 2
- 22
- 20
0
votes
1 answer
Insight.Database Auto Interface & Mapping Many-to-Many
Assuming I have the following tables:
CREATE TABLE Game
(
GameId INT,
Name VARCHAR(50)
)
CREATE TABLE UserGameJoin
(
GameId INT,
UserId INT
)
CREATE TABLE User
(
UserId INT,
Username VARCHAR(50)
)
And the following classes:
public…
Russak
- 111
- 4
- 9
0
votes
1 answer
I have a strange issue occurring with Insight.Database mapping
I'm fairly new to C# and SQL Server, and I'm attempting to map some query results to an object with 3 layers of class hierarchy. I've made it work before, and it's actually working now, but not the way that I thought it would. Here, have some…
ISmarsh
- 11
- 2
0
votes
1 answer
How to use Output Parameter with Insight.Database
I am learning Insight.Database and would like to convert the following to use a Repository.
This version works:
using (SqlConnection connection = GetConnection())
{
string errorMessage = string.Empty;
…
Greg Gum
- 33,478
- 39
- 162
- 233
0
votes
1 answer
Not Implemented Exception while using Insight.Database micro ORM
I was trying to use the cool Insight.Database micro ORM and run into a Not Implemeneted exception everytime I try to invoke the InsertCustomer method in the CustomerRepository.Any help would be appreciated
Update: I made sure that the method name…
dotnetdev_2009
- 722
- 1
- 11
- 28
0
votes
1 answer
The system cannot find the file specified,Insight.Database micro orm
I was playing around with the new Insight.Databse micro ORM to get my hands dirty.When I try to insert an object into the databe ,by using the extension method on the ConnectionStringSettings ,it throws he above error.I have the table and stored…
dotnetdev_2009
- 722
- 1
- 11
- 28
0
votes
2 answers
Unable to bind parameter in Insight.Database
I am trying to bind a parameter to a SQL query in my repository but having an error
public IList FindMovieById(int movieId)
{
return Database.Connection().QuerySql("select * from myDB.movies where ID=?", new { movieId });
}
I get…
Zo Has
- 12,599
- 22
- 87
- 149