Stack Overflow
Stack Overflow

Questions tagged [simple.data]

Simple.Data is a lightweight framework that uses the dynamic features of .NET 4 to provide an expressive, ORM-ish way of accessing and manipulating data without any of the code pre-generation and boilerplate required by other frameworks.

Simple.Data is a lightweight framework that uses the dynamic features of .NET 4 to provide an expressive, ORM-ish way of accessing and manipulating data without any of the code pre-generation and boilerplate required by other frameworks. Instead, it interprets method and property names at runtime and maps them to your underlying data-store using a convention-based approach.

128 questions
1
vote
1 answer

Passing SqlGeometry To Simple.Data Stored Procedure

I am trying to pass a SqlGeometry type to a stored procedure using Simple.Data and SQL Server 2008. The stored procedure definition looks like this: CREATE PROCEDURE [dbo].[spUpdateDamLocation] ( @DamID int, @Shape geometry ) The call I am…
Sagebrush GIS
  • 207
  • 4
  • 14
1
vote
1 answer

Calling a sql server stored procedure with output parameter when using Simple.Data

Using Simple.Data, I would like to get the result from an output parameter in a stored procedure. Let's say I have the following SP (disregard the uselessness of it): CREATE PROCEDURE [dbo].[TestProc] @InParam int, @OutParam int…
Captain JiNX
  • 93
  • 1
  • 5
1
vote
3 answers

Best practice for "var" (algorithm help)

I'm working with Simple.data, and the answer is not in the technology aforementioned but helps bring the point across. So ignore the syntax etc. I am querying a database with a simple query; but based on a set of conditions, the query will…
Dane Balia
  • 5,271
  • 5
  • 32
  • 57
1
vote
1 answer

Simple.Data can be safely used in mono today?

Some questions about Simple.Data and Mono: Can I safely choose Simple.Data for a new project using Mono today? There is the intention to maintain Mono compatibility in future versions? The features are the same as the version for Windows? Some…
fredzvt
  • 331
  • 2
  • 8
1
vote
1 answer

Simple.Data - how to bi-drectionally join on the same table twice

I know I'm close with this one... My structure is: I have some companies Each company has a primary user (account) And a list of all users (accounts). I've implemented this in the db as a companies table that has "Primary" as a foreign key to the…
tenshi_a
  • 181
  • 2
  • 10
0
votes
2 answers

Simple.Data framework: join doesn't work

I'm trying to do a simple join with Simple.Data but I can't get it working. I'm sure that I'm missing something but I don't get it... SQL: CREATE TABLE TestA ( ID INTEGER PRIMARY KEY, Txt TEXT ); CREATE TABLE TestB ( ID INTEGER PRIMARY…
MBulli
  • 1,659
  • 2
  • 24
  • 36
0
votes
1 answer

Simple.Data Lazy Loading Error

I've been playing around with Simple.Data and have run across something that I can't understand. In my data, I have three tables: Hotel, Project, and ProjectMilestone. A Hotel can have multiple Projects and a Project can have multiple…
Brian McCord
  • 4,943
  • 7
  • 32
  • 44
0
votes
1 answer

Handle Sql Server Geography datatype with Simple.Data

Its a pretty basic scenario. I have a table with a Geography datatype in a Sql Sever Database. I can access basic crud functionality via Simple.Data with all my other tables except this one. When I attempt to access the table (any method insert…
Justin Soliz
  • 2,781
  • 3
  • 25
  • 33
0
votes
1 answer

Simple.Data query by multiple values - WHERE IN ()

Using Simple.Data how can I pass multiple values to a query? Example generated SQL: SELECT a,b,c FROM GreatTable WHERE x in (1,2,3) Join support would be nice, too. Does Simple.Data allow this sort of thing?
Ronnie Overby
  • 45,287
  • 73
  • 267
  • 346
0
votes
1 answer

How can I use With and LeftJoin in the same Simple.Data Query?

I am using Simple.Data to try and build a query from our Database. Basically the results need to include certain columns from a Users table, as well as multiple rows from an Addresses table, as well as one specific column from an Entity…
JBird632
  • 1
  • 1
0
votes
1 answer

Unit test doesn't return result for joined tables

I encourage a problem when writing a unit tests which checks if function returns valid results while joining two tables. I have the following scenario: I have 2 tables, named they Folder and Item, Folder can has multiple items. Theirs DDL looks like…
MNie
  • 1,347
  • 1
  • 15
  • 35
0
votes
0 answers

Simple.Data - Format of the initialization string does not conform to specification starting at index 0

I'm using the Simple.Data ORM to hook up a database from within the Visual Studio environment that's defined in a local sql file (named convertcsv.sql). I'm following the instructions detailed here, and thus far, I've installed Simple.Data.SqlServer…
Adam Freymiller
  • 1,929
  • 7
  • 27
  • 49
0
votes
1 answer

Using INSTR (oracle function) in Simple.Data

How to use INSTR with simple.data I need to add a condition while joining 2 tables select * from table A inner join table B on INSTR(A.Column , B.Column)>0 How to write this query using Simple.Data (c#)?
ssug89
  • 249
  • 2
  • 8
0
votes
1 answer

Simple.Data - How to apply WHERE clauses to joined tables

I'm trying to use Simple.Data as my ADO, but I've run into a problem trying to put together a query that joins a couple of tables, then filters the results based on values in the non-primary tables. Scenario is a job application app (but jobs are…
Mick Byrne
  • 14,394
  • 16
  • 76
  • 91
0
votes
2 answers

Simple.Data subtract days from date time in where clause

I am using Simple.Data (version 0.19.0.0) against a SQL Server back end database and would like a query such as the one below to take 25 days from a date to compare against the date now; DateTime dtNow = DateTime.Now.Date; var pool =…
AndrewS
  • 369
  • 5
  • 19
1 2 3
…
8 9