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
1 answer
How can i connect to oracle database as sysdba using bltoolkit?
i can connect to oracle normal user successfully but when i try to connect sys user i got this error.
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
because i have to connect as sysdba but how can do it on bltoolkit ?
How can solve…
Mennan
- 4,451
- 13
- 54
- 86
0
votes
1 answer
Bltoolkit: How to cache values of instance properties
Example of Cache aspect using of Bltoolkit (http://bltoolkit.net/doc/Aspects/CacheAspect.htm) works for one instance only. If I create another instance and call cached method it will return value cached for first instance.
To achieve the goal I…
Budda
- 18,015
- 33
- 124
- 206
0
votes
1 answer
Linq query can't be converted to SQL: how to optimize the code?
Here is snapshot of my code that works fine:
var q1 = from msg in db.GetTable()
.Where(msg0 => ...)
from mt in db.GetTable()
.Where(mt0 => ...)
…
Budda
- 18,015
- 33
- 124
- 206
0
votes
1 answer
bltoolkit inserting data to a table
I have this entity :
namespace Entities.dbo
{
[TableName("tbl_snapshot")]
public class Snapshot : AbstractEntity
{
[MapField("track")]
public int TrackId { get; set; }
[Association(CanBeNull = false, OtherKey =…
Wally_the_Walrus
- 219
- 1
- 5
- 17
0
votes
1 answer
BLtoolkit association
i have this entity:
namespace Entities.dbo
{
[TableName("tbl_question")]
public class Question : AbstractEntity
{
[MapField("c_from")]
[Association(CanBeNull = false, OtherKey = "id", ThisKey = "c_from")]
public…
Wally_the_Walrus
- 219
- 1
- 5
- 17
0
votes
1 answer
bltoolkit - adding a property which is not in database table
is there any way in bltoolkit how to add to an entity property which is not mapped to the database table?
something like:
[NoMap()]
public string Something {get; set;}
?
Thanks
Wally_the_Walrus
- 219
- 1
- 5
- 17
0
votes
1 answer
BLToolkit PostgreSql connection error
I installed BLToolkit PostgreSql Data Provider 4.1.17 via package manager console. BlToolkit.4 is also installed to the project. But I couldn't connect to db yet. The error I encountered and web config is below. Any advice?
Error String:
key=value…
serefbilge
- 1,654
- 4
- 29
- 55
0
votes
2 answers
BlToolkit Oracle Guid Insert in asp .net mvc project
I tried to insert an entity to oracle database with BlToolkit. The connection is with System.Data.OracleClient. Everything is ok with ms sql server. But, when I migrate to oracle, insert for guid gives me error. Select works perfectly. Any…
serefbilge
- 1,654
- 4
- 29
- 55
0
votes
1 answer
Difference responses in SQL request and Link request using BLToolkit
I am using BLToolkit and find out an interesting behaviour. I don't understand why using the same request in link give me different results:
SQL request:
select TOP 1 * from table where coverCode='1+4'
…
user1706449
- 159
- 1
- 1
- 9
0
votes
1 answer
How to use BLToolkit generate T4 models for MySql?
the image is the project folder and files.
this is what I doing:
1.Create a Console Project.
2.in the Nuget Console input "install-package BLToolkit"
3.in the Nuget Console input "install-package MySql.Data"
4.Copy the Templates folder to root…
Du Jianyu
- 61
- 6
0
votes
1 answer
BLToolkit using a MySQL connection
I am making an attempt to establish a connection to a MySQL server using BLToolkit, and have installed MySql.Data (6.5.4), BLToolkit (4.1.12) and BLToolkit.MySql (4.1.12) via NuGet. I can make a connection to a MSSQL server in a single line, but…
Deathspike
- 8,582
- 6
- 44
- 82
0
votes
1 answer
How to add parent-child relations with BLToolkit
i'd like to add some new records to a set of tables in a parent/child relationship by using BLToolkit. Unfortunately, i can't figure out what i'm missing, since after the commit, i only have the parent rows in my database.
When I inspect the…
BigBlackDog
- 544
- 1
- 6
- 19
0
votes
1 answer
BLToolkit object as parameter
With BLToolkit, it's very easy to map from a stored procedures output to an object, but can it be done the other way? To go from an object to a stored procedures input, such that each of an objects properties becomes a parameter
I'd like to be able…
Andy Hunt
- 1,053
- 1
- 11
- 26
0
votes
3 answers
How to create Linq2Sql query that will group records from linked table and calculate 2 count fields
Here I found how to join tables using Linq2Sql and count amount of linked records LINQ - Left Join, Group By, and Count
I've implemented it and it works ok for me: the following expression
var v = from c in db.GetTable()
join t0 in…
Budda
- 18,015
- 33
- 124
- 206