I haven't tried it yet, but I don't think it will work as it stands at the moment.
I've done some work on the CF in the past and the ADO.NET implementation is a bit limited.
One of the things that will be a problem is the fact that you can't reference the columns by name. ie myDataReader.Fields("myField") doesn't work. You have to reference them by the field number.
I could probably get it to work, but it would take some time (and some testing).
All of the work would be in the populating of objects from field values after the retrieve SQL has been execute, and we would also need a data provider for SQLCE. I haven't checked on parameter usage, or join limitations either.
- Richard
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anybody try to use atoms in .net compact framework???
Is it possible?
If not, do you think that could be a very big job to make the port?
TIA
I haven't tried it yet, but I don't think it will work as it stands at the moment.
I've done some work on the CF in the past and the ADO.NET implementation is a bit limited.
One of the things that will be a problem is the fact that you can't reference the columns by name. ie myDataReader.Fields("myField") doesn't work. You have to reference them by the field number.
I could probably get it to work, but it would take some time (and some testing).
All of the work would be in the populating of objects from field values after the retrieve SQL has been execute, and we would also need a data provider for SQLCE. I haven't checked on parameter usage, or join limitations either.
- Richard