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

Which Data access technology to use for Monotouch

I'm just wondering what people are using for a Data Access Layer in Monotouch? I'm working on a CRUD based app, and looking for something in between writing inline SQL or rolling my own ORM, and trying to wedge Entity Framework into the mix when…
Kye
  • 5,919
  • 10
  • 49
  • 84
1
vote
1 answer

Simple.Data with MySql - "Multiple ADO providers found" exception when opening a database connection

In the latest version of Simple.Data (1.0.0-beta2) I am using MySql as my database (version 5.5.2.1). I am using the latest MySql.Data assembly as a provider to connect to the database. When I try opening a connection to my local MySql database in…
contactmatt
  • 18,116
  • 40
  • 128
  • 186
1
vote
1 answer

Simple.Data Error Selecting More Than 100 Rows

I'm playing around with using Simple.Data for my next project, and ran across something that seems like a bug. If I try to use the All or FindAll function for a table and the result set is more than about 100 rows (sometimes I can get 101 or 102,…
Brian McCord
  • 4,943
  • 7
  • 32
  • 44
1
vote
1 answer

Schema generation with Simple.Data?

Is there a way to perform database schema generation with the Simple.Data library (similar to how Fluent NHibernate does it)? If not, is there a way to run DDL (Data Definition Language) commands against a database via the Simple.Data…
Ken Burkhardt
  • 3,528
  • 6
  • 33
  • 45
1
vote
2 answers

Simple.Data.UnresolvableObjectException - No matching procedure found, or insufficient permissions

I have a SQL 2008 Express DB and am trying to run an insert query. But every time I run the query I get the UnresolvalbeObjectException. Dim db =…
Periop IT
  • 21
  • 2
1
vote
0 answers

Simple.Data in ASP.NET Core - 'No Ado Provider found.'

To my application in ASP.NET Core I have added from nuget - Simple.Data.SqlServer. And in my Code: var db = Database.Open(); in this line I recives an error: "No Ado Provider found" I assume that it's because my Startup.cs (file is in different…
DiPix
  • 5,755
  • 15
  • 61
  • 108
1
vote
1 answer

Cannot insert a record with Simple.Data

I am using Simple.Data and I receive the following error at the last line when trying to run the code below: An unhandled exception of type 'System.ArgumentException' occurred in System.Core.dll. var db =…
jaromey
  • 666
  • 2
  • 10
  • 27
1
vote
0 answers

Simple.Data select a constant value into column

Is there a way with Simple.Data to add a column to a query where the column will just contain some constant? For example it would be similar to this query: SELECT Name, 'Unpaid' AS Status FROM table; I would like to do something similar to the…
Reasurria
  • 1,808
  • 16
  • 14
1
vote
1 answer

Simple.Data and Sql Azure Transient fault handling

One of the things in my todo list is to download and grok the Simple.Data's Github code one day, but until then I was wondering if the framework already handles the Transient faults (by retry logic or otherwise) as mentioned here…
Raghu
  • 2,678
  • 2
  • 31
  • 38
1
vote
1 answer

Simple.Data does not recognize my new table

We have a web application which creates a new table in SQL Server during a particular administration function. When I query this table using Simple.Data in an other part of the application I receive an unresolvableobjectexception as if…
1
vote
1 answer

Casting to objects having properties with same names

I have a problem when i try to cast to class Foo having Bar property. Properties of the class Bar have the same names as the properties of the class Foo: public class Foo { public int Id { get; set; } public string Name { get; set; } …
1
vote
1 answer

simple.data orm, how to search by date?

I am using simple.data for my project. I have a column createdDate. this is a datetime column. if i passed in a date string "05/06/2006". I need to get all records created in that day. how can i do that using simple.data? following code is not…
qinking126
  • 11,385
  • 25
  • 74
  • 124
1
vote
1 answer

Cannot see Simple.Data trace messages

I cannot seem to view the trace messages for the Simple.Data library. I am using the Postgresql provider. I have added the following to the web config to ensure all the messages will come through: system.diagnostics>
Paul Grimshaw
  • 19,894
  • 6
  • 40
  • 59
1
vote
1 answer

simple.data orm: how to get max value?

I am using simple.data orm. try to get the max value from the table. couldn't get it work. var latestVersion = _db.AMBest.Version.Max(); AMBest is the table. Version is the the field in AMbest table. I need to get the latest version, but my code…
qinking126
  • 11,385
  • 25
  • 74
  • 124
1
vote
0 answers

Sharing connections Simple.Data.UnresolvableObjectException

I have just plugged in application insights into my azure web role which is using simple data. In the exception view in Application Insight I am seeing exception's occurring for every database call for both UseSharedConnection and…
DShorty
  • 582
  • 1
  • 6
  • 14
1 2
3
8 9