Comments by Member 13039327 (Top 5 by date)

Hello RickZeeland,

Thanks for the reply. But I'm sorry, I'm not sure what you mean with database-agnostic. Do you mean that when I have used the ORM, I can attached any kind of database to it, without changing any coding (except maybe the connection string) ??

So if I create a project with ORM and use Access Database and later I want to go using a SQLServer database, I only need to change the connection string?

And also thanks for the link, don't hard code your dataProvider. But this is not about Linq, so I am not sure how it is being in Linq. If the code remains the same, regardless the type of database.

Regards,
Hans

Hello Zsolt,

Indeed I have already the database in Access (accdb). But even if I would create thru VB, that wouldn't change the problem, if I would change the maximum size or property of a field in the database. Then I still need to walk thru whole code to make sure the text length/type will be correct. Or I would need to do by variable. But that I think doesn't work that clean.

Hello Richard,

For the tet boxes, I want them to have the same size as the database. So the user is not typing in 30 characters, while only 20 can be used in the database field.

Or the the user is entering letters, while the database only excepts numbers.

The reason why I want to have this by code is that there are fields that will be used by different tables/fields.

Also do I want to have this by code, that if I change the database field property, the program will automaticaly adjust the size/property of the textfield and I don't need to go thru all those manualy again, to make it to match with the databasefield settings.

Regards,
Hans

Hello Richard,

Sorry but this was my mistake. I did try to change the row in access to rwAuthUser and changed this also in the VB. But forget to adjust in the above code. But it still doesn't change the problem.

I even did try only to update tbLocalDataFolder (LocalDB) and tbServerDataFolder (ServerDB) but I keep getting the error. Also when I only try to update tbLocalDataFolder (LocalDB) the error is being thrown. This also when I am trying to update an other table. With the exception of tbUsers (UsersDB). For with tbUsers it will update indeed the DB
It seems like somewere it is mixing the rows or something like that. Or that it is checking all the rows and wants to update all of them in table