Re: Build ADO.NET ResultSets for Merge Replication. by iKiLL
iKiLL
Tue Mar 20 05:25:09 CDT 2007
Again Ginny, thanks for the response.
It is as you said in the first paragraph. And that is exactly how this
question came about.
I will I am not to bothered about the intellisense. And if there is no real
performance implication then i may as well use an untyped Result set.
Thanks,
ink
"Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in message
news:310AF606-2DC9-4F3E-8643-533CC5949D22@microsoft.com...
> There is a designer in VS 2005 that you can use to create strong typed
> SqlCeResultSet classes. You follow the same steps that you use to create a
> typed dataset, except you change the property on the xsd file from
> MSDataSetGenerator to MSResultSetGenerator. Probably you found this
> already, and probably you also found that it needs the SDF file already so
> it can read the schema to generate the classes.
>
> One approach would be to pull the table you want so now you have a SQLCE
> table, but since you're going to have to update your typed resultset code
> each time there might be changes in the schema of the table you download,
> it might end up being simpler to use untyped resultsets instead. The
> downside of doing this is that you don't get the Intellisense assistance
> and data casting that the strong typed resultset provides. The performance
> is going to be about the same either way since the typed resultsets are
> very lightweight.
>
> --
> Ginny
>
>
> "iKiLL" <iKill@NotMyEmail.com> wrote in message
> news:O%23SCihkaHHA.3584@TK2MSFTNGP02.phx.gbl...
>> Hi Ginny
>>
>> Yeah this is what i am wanting to do but i was hoping to create it in the
>> IDE as an XML file so that it is Strong typed.
>>
>> ink
>>
>>
>>
>>
>>
>> "Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in
>> message news:61D6A92B-B331-4F4A-A4F3-8B51A69AD3CF@microsoft.com...
>>> ink,
>>>
>>> You have to have the database before you can connect to it, but you can
>>> write code that creates a SqlCeResultSet programmatically once you have
>>> that connection. Is this what you want to do?
>>>
>>> --
>>> Ginny
>>>
>>>
>>> "iKiLL" <iKill@NotMyEmail.com> wrote in message
>>> news:eT61etiaHHA.5032@TK2MSFTNGP02.phx.gbl...
>>>>
>>>> Hi all
>>>>
>>>> I am developing in C#, CF2 and SQL Mobile.
>>>>
>>>> Currently my app is using Merge Replication. This is all working well.
>>>>
>>>> I have now decided to try and use Result sets in my application but I
>>>> am not sure on how to handle this.
>>>>
>>>> I have gone through examples on how to build a result set, but my
>>>> application creates the Database the first time it syncs.
>>>>
>>>> How do I build a result set for a database that does not exist yet?
>>>>
>>>> Thanks,
>>>> ink
>>>>
>>>>
>>>
>>
>>
>