Comments (8)
How are you building the query? If you are using SqlBuilder or a plain string, you are responsible for the column to property mapping.
from dbextensions.
var query = SQL.SELECT("TOP (1) *").FROM("MyTableName"); var execution = _db.Map<MyTableName>(query)?.First();
Isn't this the correct way?
from dbextensions.
Try this:
var execution = _db.Table<MyTableName>()
.First();
from dbextensions.
Try this:
var execution = _db.Table<MyTableName>() .First();
Gives the same result back as my previous code.
Seems like Column name property is not working correctly? Which is bad for me because there are some columns that start with numbers on my database and C# does not accept numbers as property names.
[Column(Name = "ColumnName")]
from dbextensions.
Are you using the Table attribute on the entity class?
from dbextensions.
Are you using the Table attribute on the entity class?
[Table(Name = "MyTableName")]
public class MyTableName
{
[Column(Name = "nOffer")]
public int Offer { get; set; }
}
Yeah like this.
This code :
var query = SQL.SELECT("TOP (1) *").FROM("MyTableName");
var execution = _db.Map<MyTableName>(query)?.First();
and this one:
var execution = _db.Table<MyTableName>().First();
Returns a row but the Offer parameter is value 0. In the database nOffer value is 257.
from dbextensions.
I cannot reproduce the issue. If you call _db.Table<MyTableName>().GetDefiningQuery().ToString()
what do you get? That way we can find out if it's using the column name or not.
from dbextensions.
Aha my bad it all makes sense right now.
DbExtensions uses the given Column name value to build SQL like:
SELECT [nOffer] AS [Offer]
FROM [MyTableName]
So if i build a query using DbExtensions SQL object i should type it as follow:
SQL.Select("TOP 1 [nOffer] AS [Offer]");
Which returns the correct database value.
Thank you very much for the support.
from dbextensions.
Related Issues (20)
- Need to "extend" clause HOT 1
- dotnet core version HOT 23
- Support explicit DbParameter on CreateCommand HOT 3
- Add support for CROSS_JOIN to SqlBuilder HOT 2
- Async support HOT 7
- CommandTimeout setting HOT 4
- Accessing CommandTimeout property HOT 1
- Support updates when using updatable keys HOT 1
- LIMIT and OFFSET incorrectly adding {0} instead of actual value. HOT 1
- Please create a DotNet Standard Version. HOT 1
- Compile with C# 8 to leverage nullable reference types annotations HOT 1
- Association with multiple keys HOT 4
- Error using SqlSet using depth path HOT 2
- Add support for .NetStandard 2.1 HOT 1
- Hitting SQL 2100 parameter limit HOT 3
- Use same parameter when value is the same HOT 6
- Expose table name metadata
- .NET 6 support? HOT 2
- [self-resolved] ._ForEach<T>() behaves differently depending on .NET environment ?
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dbextensions.