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
0
votes
1 answer

Simple.Data building the Select Statement Dynamically

Is there a way to build the Select statement in parts? I am building a dynamic query by working through loops, which works well for the FROM / JOIN aspects, but can't make the Select work... e.g. rather than this: var results = query.Select( …
Paul Grimshaw
  • 19,894
  • 6
  • 40
  • 59
0
votes
1 answer

Issues while selecting values into nullable type property in Simple.Data

I have a integer column in the database which is nullable. So while creating the datamodel i made the property "int?". This way my insert/update statement is working as expected. However when I try to select data from the table into the same…
Anoop
  • 418
  • 6
  • 19
0
votes
1 answer

Simple.Data nested join retrieval

I'm using Simple.Data but can't seem to get it to fully populate my related objects from a single query. I've checked some of the other questions on StackOverflow but nothing has so far been successful. I have objects: public class ProductVersion { …
Martin1968
  • 13
  • 3
0
votes
1 answer

Simple.Data Sqlite Insert returns Null

Im using Simple.Data to insert data into an Sqlite database. I read on the wiki that Insert returns the inserted data. I need to get the latest rowID (identity). But I get Null instead. Using the Stable version from NuGet. var db =…
Sugarel
  • 811
  • 1
  • 13
  • 22
0
votes
3 answers

How to write Simple.Data query to join two tables?

I need to write Simple.data queries for following SQL queries can you help me ? SELECT Table1.UserID, Table1.we, Table1.ba, Table1.re, Table1.rtes, Table1.datae, Table1.void, Table1.deletee FROM Table1 INNER JOIN Table1 ON…
user3044294
  • 205
  • 1
  • 15
0
votes
1 answer

Simple.Data, how to select when column name contains ?, -, / and other special character?

I am using Simple.Data to query the DB. but this particular DB is imported from Access DB. some of the filed names has space, -, / in it. Policy Number FTZ? Prod/Co Covg - Years is it possible to use Simple.Data? how do you name your object so…
qinking126
  • 11,385
  • 25
  • 74
  • 124
0
votes
1 answer

Unit testing calling of stored procedures that return a value with Simple.Data

I have the following stored procedure: [dbo].[MyStoredProcedure] @field1 int, @field2 int, @field3 nvarchar(5), @returnValue int output I call it using Simple.Data and get the return value as follows: var result =…
Dave S
  • 1,403
  • 1
  • 15
  • 23
0
votes
1 answer

Insert One to many and many to many data using Simple.Data

I am using Simple.Data ORM to handle my DB operations. I am not sure how to handle the case of inserting One to many and many to many data. Say for example I have a customer and order table and I want to save data with one customer and two orders.…
Afraz Ali
  • 2,672
  • 2
  • 27
  • 47
0
votes
0 answers

How to exclude certain fields from being loaded to a POCO by Simple.Data FindAllBy?

I have a table I want to query with Simple.Data FindAllBy() and load it into a POCO. However, there is one field in the table with binary data that I want to be excluded from this query. How can I exclude this column from being loaded by…
Earlz
  • 62,085
  • 98
  • 303
  • 499
0
votes
1 answer

SimpleData casting objects with ALL_CAPS and underscores

I'm not sure if anyone else has run into this, but I am having a heck of a problem when trying to cast returns from an Oracle database that has column names in ALL_CAPS with underscores. I am trying to figure out a code way to get it done, but it…
jdscolam
  • 988
  • 8
  • 20
0
votes
1 answer

Predefining joins in Simple.Data

I have a table Users with a foreign key to another table Department. The User object has a POCO for the department. I can select a user with the department-poco being populated with the following Simple.Data by-id…
Tobias
  • 4,999
  • 7
  • 34
  • 40
0
votes
1 answer

Buffer Overflow error while using Simple.Data.Oracle

I am using Simple.Data.Oracle to insert data in a table. I am trying to insert a very large value in one of the columns and it is giving me the following error ORA-22835:Buffer er for lille til konvertering af CLOB til CHAR eller BLOB til RAW…
Afraz Ali
  • 2,672
  • 2
  • 27
  • 47
0
votes
1 answer

How to use Table type in Simple.data

How can I make use of TableTypes in Simple.data for following query: //Type -MyType GId int StartDate datetime EndDate datetime //Table - MyTable Id int GId int Text varchar StartDate Datetime EndDate Datetime Select * from MyTable T1 inner join…
user2877802
  • 3
  • 2
0
votes
2 answers

Increment an integer in a Simple.Data Update query

Is it possible to increment an integer in an Update query using Simple.Data? My database is SQL Server, but I know Simple.Data is designed to be database agnostic so perhaps this query is not available in other providers. The SQl query I am trying…
Dave S
  • 1,403
  • 1
  • 15
  • 23
0
votes
1 answer

Does anybody know of any Simple.Data.Azure sample projects?

I can't seem to find any documentation or sample projects on using simple.data.azure. Does anybody know of any?
ctb
  • 131
  • 3
  • 11
1 2 3
…
8 9