I access DB via BLToolkit. One of my tables has:
fields: Id, TeamId, PlayerId, Val1, Val2
primary key - field Id, autoincremented
composite unique key which consists from 2 fields TeamId and PlayerId
data fields Val1, Val2
I've created list of…
I'm using BLToolKit as a ORM Mapper.
My problem is, that it generates the wrong SQL.
I have this query:
var qry = from i in s.Query()
join o in s.Query() on i.Id equals o.ChannelID into p1
select…
I have collection of users identified by property Id and for each user I want to update his username to something like username+"!".
In bltoolkit I try it like this:
using(var db = new DbManager)
{
foreach(var user in users)
{
…
We're using BLToolkit library in our ASP.NET MVC 4 application. I get an "Operation is not valid due to the current state of the object" when trying to execute the LINQ statement below:
public List…
We have a legacy system which has the ability to add custom fields to its entites. This feature is implemented badly, to be exact: each entity table is extended with fields Custom1, ... Custom 10, and moreover, there's big table CustomFields…
I have been trying to use BLToolkit to activate an Oracle stored procedure which takes a User Defined Type as an argument as an output parameter and changes it.
I have managed to do this on a primitive type, and and also by manually calling…
I'm trying to write a code that will be translated into the following query:
SELECT * FROM players WHERE Id IN (xxx)
With MS-SQL and linq2sql I used "Contains" construction and that worked well.
Now (for MySQl and BLToolkit) I did it this way:
…
I have 2 entities:
[TableName("is_userrole")]
public class UserRole
{
[MapField("id"), PrimaryKey, Identity,
public Guid id;
[NotNull]
public string Name;
}
[TableName("is_users")]
public class User
…
I receive an exception running my T4 template:
Running transformation: System.ArgumentNullException: Value cannot be null.
Parameter name: type
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at…
i have a enum like that :
public enum Mode
{
[*"I need a display name attribute to show in combobox"*]
Active,
[*"I need a display name attribute to show in combobox"*]
DeActive
}
I want to use it as a dataSource in a comboBox and i need to set…
want to generate my data layer using bltoolkit, T4 templates and postgreSQL. I receive an exception running my T4 template, based on the one suggested by the documentation:
Error 5 Running transformation: System.ArgumentNullException: Value cannot…
I am currently using Entity Framework Code First to generate my MySQL tables and schema from my classes. However, I would like to switch to BlToolkit. Does this ORM support table generation from classes decorated with various attributes? If so, can…
I'm trying to create new application using BLToolkit but i can't compile the code, i get this error:
The type or namespace name 'DbManager' could not be found (are you
missing a using directive or an assembly reference?
This class is described…