snotratech.com

Few days ago I have noticed that is microsoft phasing out gotdotnet site. The pity news, it was a great place to share articles and resources

Two months ago I  publised my first article. I can say that results was not disapointed me. Traffic had been increased and google PR of main page had been also increased from 0 to 5. Not so bad I think.

This is my second artcile http://www.snotratech.com/articles/currowrefresh. Here I explain how to refresh current record in ADO.NET program and give code example. Also I give example with Snotra Tech Oracle Components. So programmers can compare and think what is better: make their own classes or use Snotra Tech Component that support this feature by default. Wish you pleasant reading .

I finished first article and have posted it to CodeProject. It has name: “Concurrent model in ADO.NET, ways that allow to negotiate disconnected model restrictions for Oracle databases”. Code Project has published it here:

http://www.codeproject.com/cs/database/concurmodel.asp but of cource they cuted all information concerning Snotra Tech Oracle Data Components. So here I publish complete version of article:

http://www.snotratech.com/articles/concurmodel/

But c-sharpcorner have published my article completely.

http://www.c-sharpcorner.com/UploadFile/milonov/concurmodel12062006135848PM/concurmodel.aspx

I’m writing an article where I talk about ado.net usability for desktop applications, make code advices concerning writing programs that should work under multiuser concurrent environment, explain the main principles of record locking under oracle database and how to avoid ADO.NET disconnected model restrictions when developing desktop application using .NET. Article will contain code examples for Snotra Tech Oracle Data Components also. Hope it will be useful for ADO.NET programmers.

Posting in catalogs was almost one week later… As I expected, it had no big influence on site traffic, but it gave me incoming links and traffic became more quality, at least I have more downloads from my site…. So on can argue about this posting profit at least it didn’t make any bad. Now I have about 40 visitors daily but I need at least 300.

As for forums and blogs, I think people don’t want to be a first person… For example if visitor see forum with hundreds of posts he decide that it’s cool forum and hurry up to join it, despite it can be fake posts… but if he see few posts and other people visitor is afraid and hurry up to leave forum… But why? If he have some question will be more logically to ask them but not to leave forum or blog…. At least you welcome .

After one month of silence google had started to index my site has appeared in search results . So now I have some traffic from google and the percent of the one is increasing… It’s very good

Have registered Snotra Tech in about 350 download catalogs using robosoft. Very funny software, trying to estimate the benifit of such action…. IMHO back links at least are useful things, but as for sellings, components are so specific goods and I should promote them in special forums (see below), should write and post programming articles and it is sxactly what I’m going to do…

Found some good forums concerning oracle and .net. I think that can share my oracle and .net expirience so i’m starting to help people. My oracle components also can help…. So I’m on the right way…

Forums list:

http://www.codeguru.com/forum/forumdisplay.php?f=14

http://forums.oracle.com/forums/forum.jspa?forumID=146

http://forums.oracle.com/forums/forum.jspa?forumID=228

http://www.thescripts.com/forum/forum139.html

and some from http://groups.google.com

So as I understand from the conversation with Nur Hidayat:

a) ODP.NET and ODT.NET don’t lock record when user posts it in DB, so programmer should care about it himself for example writing some stored procedured or to lock entire data block using “select for update”

b)if you have server generated values (for example trigger changes column after insert), you should refresh all datatable or write special code to refresh only one record….

Too complex for such kind of tasks, for example Delphi components DOA or ODAC can do so without any problems… but under .net it doesn’t exist…. Strange…

So IMHO my Snotra Tech Oracle Components for .net should be useful not only for me….

Have participated in thread on http://forums.oracle.com . The full link is here:http://forums.oracle.com/forums/thread.jspa?threadID=432200&tstart=0

The text of discussion:

//——————————– 

Dear nurhidayat.

Agree with you concerning advances of oracle DB at all and locking strategy especially, but the question is about realization of locking strategy when using ODP.NET or ODT.NET. For example is it possible to lock currently editing row and unlock when user is going to another row at least using DataAdapter or smth. else without writing lots of code? Or can I see changes in my DataTable after the row was posted if I have server generated value for some column (for example by after insert trigger)? Simply it is very common problems so any advices to don’t reinvent the wheel will be great.

Thank you,
Michael.
//———————–

from nurhidayat: 

> For example is it possible to lock currently editing row and unlock when
> user is going to another row at least using DataAdapter or smth. else
> without writing lots of code

if you really want to prevent other user from reading what we’re updating, then user SELECT … FOR UPDATE to fill your datatable, do some manipulation, and then write back datatable content into database. no extra coding, just revise you select statement.

> Or can I see changes in my DataTable after the row was posted if I have server
> generated value for some column (for example by after insert trigger)?

Never tried this, but I think not, you still have to re-fill your datatable, but we can use change notification feature to let oracle alert us when there are modification on underlying table.

regards.
//———————

>if you really want to prevent other user from reading what we’re updating, then user SELECT … FOR UPDATE to fill your datatable, do some manipulation, and then write back datatable content into database. no extra coding, just revise you select statement.

yep and lock all data in selected block… Then user go to smoke and all another users wait for him if willing to change data from selected block… No, application should make “select for update” in the moment when user posts edited record and only one record, not all selected block, IMHO it is right solution for multiuser concurrent environment.

Anyway,
thank you, Michael.

//————————— 

From NH: 

Yes, as far as my knowledge, oracle will lock the entire block not only the selected row. that’s why I put “if you really want to…” in the first place.

Personally, I rarely use this SELECT FOR UPDATE statement. I once use this mechanism to to generate non-skipping invoice number in multiuser environment and the application doesn’t issue SELECT FOR UPDATE directly, instead tha application call a stored procedure (which has SELECT FOR UPDATE in it) to get the invoice number.

Regards,
NH

Anyway it is third week that I became internet market-maker but not only developer and architect. I can’t say that these three weeks gave me lot of money or celebrity, but the process of marketing is really exciting for me. It just like going to the party, you can get lots of new friends, hear the latest news; or like business lunch, you can talk with good and helpful person….

When I only placed my site on the global informational space I make some helpful things: I registered it in about forty download catalogs, in search engines… Made this blog to share my opinion and experience with people… And now I’m going to discuss and I will discuss about ADO.NET and Oracle problems in relevant forums… On the one side I hope to get a good answers on my questions, on the other hope people will interesting in my solution of ADO.NET problems… So good luck, mike (it I say for myself).