While searching around the net for light, fast ORMs targeting .NET, I came across BLToolKit, which seems absolutely amazing in terms of performance, openness, maintainability, and flexibility.
However, I've also noticed that it has received very…
i search to work with data accces orm faster and speed for fetch and implementation
I came across BLToolKit in the OrmBattle http://www.ormbattle.net/, which seems absolutely amazing in terms of performance, speed ,maintainability, and…
I'm not too big of a fan of direct entity mappers, because I still think that SQL queries are fastest and most optimized when written by hand directly on and for the database (using correct joins, groupings, indexes etc).
On my current project I…
Does BLT support Oracle stored procedures? I've tried numerous methods, described below to get it to work but no luck. The stored procedure updates a table with several values. This is the stored procedure, a small test procedure.
DROP PROCEDURE…
If I have one-to-many relation between two entities (ie. Post and Comment) and have my master class defined as:
public class Post {
...
IList Comments { get; set; }
}
But my Comment sub-related class doesn't have a property of type…
I haven't found a way to retrieve two lists of objects from an SP with two select statements.
Is it possible with BLToolkit, or can only hierarchical data be fetched in such a manner?
I'm trying to replace a dataset containing two unrelated tables.
I want to avoid blocking the executing thread by slow database read , and I like BLToolkit DataAccessor very much
public abstract class PersonAccessor : DataAccessor
{
[SqlText(@"SELECT * FROM Person WHERE FirstName = @firstName")]
public…
I light of recent (extreme) performance issues with SubSonic 3, we are looking to migrate ORMs, preferably rewriting as little code as possible(which is mostly Linq).
So I am looking at BLToolkit. One of the major differences I see between SubSonic…
My table schema (excerpt)
create table dbo.MyEntity
(
MyEntityID int identity not null
primary key,
Name nvarchar(50) not null
unique,
Description nvarchar(500) null,
-- these two are optional fields
MaxCount int…
Is it possible with BLToolKit (http://bltoolkit.net) to create a set of records for list of object (batch insert)?
If yes, how is this possible?
Thanks a lot!
My application is running under ASP.NET 4.0, which uses BLToolkti as ORM tool.
I have some queryable expression:
var q = db.GetTable()
.Where(tb=>tb.TeamId==MyTeamId && tb.Season==MySeasonId)
.OrderByDescending(tb=>tb.Id)
.Take(20)
…
Basically i am trying to deserialize data that is inside an byte array into objects. I am trying to use GetString method of UTF8 Encoding in order to read a string. Here is part of my code:
var mm = new DynamicMethod("get_value", typeof(object)
…
I start using BLToolkit and there is a new advantage: InsertOrReplace
When I try to use it there is an exception:
"InsertOrUpdate method does not support identity field 'Margin.id'"
My Model here:
[TableName("Margin")]
public class Margin
…
I would like to know the best way to obtain long from returned BIGINT value from MSSQL server via BLToolkit
which will be better?
long.Parse(db.Parameter("@rowCount").Value.ToString());
or
System.Convert.ToInt64(db.Parameter("@rowCount").Value);
?
When working with Linq to SQL you can use DataLoadOptions to specify which "child" objects to load. Is there a similar technique with BLToolkit?
It's nice that with BLT I can create the BO directly, like:
from p in db.Parent
select new Parent
{
…