Business Logic Toolkit for .NET.
This tag is for questions related to the Business Logic Toolkit for .NET (BL Tookit).
Questions tagged [bltoolkit]
89 questions
0
votes
3 answers
BLToolKit: how to fetch 'empty' datetime field?
Request Execute is failed if one of fields to be mapped has DateTime field and corresponding value in DB has '0000-00-00' or '0001-01-01'. The following error is returned
Unable to convert MySQL date/time value to System.DateTime
Is there any…
Budda
- 18,015
- 33
- 124
- 206
0
votes
2 answers
BLToolkit-mysql-connector exception: Could not load file or assembly MySql.Data, Version=6.9.7.0
I am using BLToolKit (ver. 4.3.2.0) and MySql Connector (BLToolkit.Data.DataProvider.MySql.4 of version 4.3.2.0) from NuGet.
When I run my web.app in the mono-environment all work perfectly. But on the IIS I get an exception:
FileLoadException:…
maxkoryukov
- 4,205
- 5
- 33
- 54
0
votes
1 answer
What is bltoolkit's BLTgen tool and how it should be used?
I guess it is something like sgen.exe which generates some serialization classes in separate assembly. Is that it? Should generated assembly be referenced? If so, by which project?
I have noticed that some LINQ queries are very slow, when executed…
Marko
- 5,437
- 4
- 28
- 47
0
votes
1 answer
Why BLToolkit inserts \0 instead of '@' symbol in generated queries?
I use BLToolkit with mysql and when I try to insert a record to a table, I am getting a query like this:
INSERT INTO `P`
(
`Name`
)
VALUES
(
\0Name
);
As you can see, this not the best mysql query.
Classes:
public class P
{
…
maxkoryukov
- 4,205
- 5
- 33
- 54
0
votes
1 answer
How to invalidate cached property?
In my ASP.NET web site I persist objects retrieved from DB for some time and make sure that the only single instance of object is created per DB record.
I also use [InstanceCache] to cache calculated value for one of business objects, object is kept…
Budda
- 18,015
- 33
- 124
- 206
0
votes
1 answer
How to pass DataTable as parameter in BLToolkit?
I get an error when I try to do this.
And here is my code.
public abstract void SaveSchedule(DataTable items);
The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Table-valued parameter 1 ("@items"),…
Anna Prosvetova
- 1,427
- 2
- 10
- 14
0
votes
1 answer
What means 'maxBatchSize' parameter in InsertBatch method
BLToolkit has InsertBatch method to insert a set of objects.
What is the meaning of 'maxBatchSize' parameter? I was not able to find any documentation on that, neither that clear from source code.
Please advise.
Thanks.
P.S. I believe that is…
Budda
- 18,015
- 33
- 124
- 206
0
votes
1 answer
BLToolkit: Can't make ScalarSource in DataAccessor work
I have SP like this
CREATE PROCEDURE dbo.pPersonGetIDByName
@Name nvarchar(50),
@ID int output
AS ...
and appropriate DataAccessor method
[ScalarSource(ScalarSourceType.OutputParameter)]
abstract int GetIDByName(string Name);
I understand it as…
Alsin
- 1,514
- 1
- 14
- 18
0
votes
2 answers
Is there any class generator for bltoolkit?
Is there any class generator for bltoolkit?
Sami Beyoglu
- 317
- 4
- 10
0
votes
1 answer
Extract expression from BlToolkit LINQ so it can be compiled
Im trying to extract this expression:
t => t.DayEnd == s.DayEnd && t.DayStart == s.DayStart
into extern variable called expression.
And I want it to extract it in a way so i can use this variable in the next BlToolkit LINQ query.
private void…
John Smith
- 1,783
- 6
- 22
- 36
0
votes
2 answers
force blToolkit to insert parameters
I use BlToolkit and want it to do not use parameters in final compiled query.
EXAMPLE:
The query it compiles :
-- Sql MsSql2005
-- DECLARE @p1 Int64
-- SET @p1 = 101671702
SELECT * FROM dbo.Table1 WHERE Id = @p1
but I want it to compile like…
John Smith
- 1,783
- 6
- 22
- 36
0
votes
2 answers
How to add a constant into LINQ query in BLtoolkit
Im trying to add a constant to a LINQ query in BLtoolkit.
var query = dbManager.Table.Select(x=>new { x.column, cnst = 1 });
but in the result there is only 'column' column, but no 'cnst' column.
John Smith
- 1,783
- 6
- 22
- 36
0
votes
1 answer
BlToolkit insert data failure in BaseRepository class
I'm using BaseRepository in asp .Net MVC project. Edit operation works but in Add operation, I should make a trick to make it work. In detail, my base repository and BaseEntity classes:
public class BaseRepository : IRepository
serefbilge
- 1,654
- 4
- 29
- 55
0
votes
1 answer
Bltoolkit Manage DbManager in repository pattern (ASP.Net)
I'm using bltoolkit in my ASP.Net application , I use repository pattern to manage my data access layer. foreach operation i open a new DbManager . I cannot find a way to open and dispose the DbManager Object per request or session . any ideas
user2971927
- 3
- 2
0
votes
1 answer
Exists in BlToolkit
is it possible to write such a query via linq in BlToolkit?
SELECT * FROM X pd
WHERE EXISTS (SELECT 1 FROM Y mm
WHERE VersionMaster > 0
)
I mean - is it possible to write an 'Exists' construct in linq so the BlToolkit would understand it?
thanks
John Smith
- 1,783
- 6
- 22
- 36