This HTML5 document contains 30 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

PrefixNamespace IRI
n16http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/VirtTipsAndTricksGuideInsertRDFUsingVStudio/sioc.
dctermshttp://purl.org/dc/terms/
atomhttp://atomowl.org/ontologies/atomrdf#
foafhttp://xmlns.com/foaf/0.1/
n14http://vos.openlinksw.com/dataspace/services/wiki/
oplhttp://www.openlinksw.com/schema/attribution#
n4http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/
dchttp://purl.org/dc/elements/1.1/
n2http://vos.openlinksw.com/dataspace/dav#
rdfshttp://www.w3.org/2000/01/rdf-schema#
n13http://rdfs.org/sioc/services#
siocthttp://rdfs.org/sioc/types#
n8http://vos.openlinksw.com/dataspace/person/dav#
n7http://vos.openlinksw.com/dataspace/owiki/wiki/
rdfhttp://www.w3.org/1999/02/22-rdf-syntax-ns#
n12http://vos.openlinksw.com/dataspace/owiki#
xsdhhttp://www.w3.org/2001/XMLSchema#
n17http://vos.openlinksw.com/dataspace/person/owiki#
siochttp://rdfs.org/sioc/ns#
Subject Item
n8:this
foaf:made
n4:VirtTipsAndTricksGuideInsertRDFUsingVStudio
Subject Item
n2:this
sioc:creator_of
n4:VirtTipsAndTricksGuideInsertRDFUsingVStudio
Subject Item
n14:item
n13:services_of
n4:VirtTipsAndTricksGuideInsertRDFUsingVStudio
Subject Item
n12:this
sioc:creator_of
n4:VirtTipsAndTricksGuideInsertRDFUsingVStudio
Subject Item
n7:VOS
sioc:container_of
n4:VirtTipsAndTricksGuideInsertRDFUsingVStudio
atom:entry
n4:VirtTipsAndTricksGuideInsertRDFUsingVStudio
atom:contains
n4:VirtTipsAndTricksGuideInsertRDFUsingVStudio
Subject Item
n4:VirtTipsAndTricksGuideInsertRDFUsingVStudio
rdf:type
sioct:Comment atom:Entry
dcterms:created
2017-06-13T05:46:38.470035
dcterms:modified
2017-06-29T07:41:35.618464
rdfs:label
VirtTipsAndTricksGuideInsertRDFUsingVStudio
foaf:maker
n8:this n17:this
dc:title
VirtTipsAndTricksGuideInsertRDFUsingVStudio
opl:isDescribedUsing
n16:rdf
sioc:has_creator
n2:this n12:this
sioc:content
%META:TOPICPARENT{name="VirtTipsAndTricksGuide"}% ---+How can I insert RDF data from Visual Studio to Virtuoso? The following example shows how to insert RDF Data from Visual Studio to Virtuoso: <verbatim> using System; using System.Runtime.InteropServices; using System.Text; using System.Data; using OpenLink.Data.Virtuoso; #if ODBC_CLIENT namespace OpenLink.Data.VirtuosoOdbcClient #elif CLIENT namespace OpenLink.Data.VirtuosoClient #else namespace OpenLink.Data.VirtuosoTest #endif { class Test_Insert { [STAThread] static void Main(string[] args) { IDataReader myread = null; IDbConnection c; c = new VirtuosoConnection("HOST=localhost:1111;UID=dba;PWD=dba;Charset=UTF-8"); IDbCommand cmd = c.CreateCommand(); int ros; try { c.Open(); cmd.CommandText = "sparql clear graph <ado.net>"; cmd.ExecuteNonQuery(); cmd.CommandText = "sparql insert into graph <ado.net> { <a> <P01> \"131\"^^<http://www.w3.org/2001/XMLSchema#short> }"; cmd.ExecuteNonQuery(); cmd.CommandText = "sparql insert into graph <ado.net> { <a> <P02> \"1234\"^^<http://www.w3.org/2001/XMLSchema#integer> }"; cmd.ExecuteNonQuery(); cmd.CommandText = "sparql insert into graph <ado.net> { <a> <P03> \"12345.12\"^^<http://www.w3.org/2001/XMLSchema#float> }"; cmd.ExecuteNonQuery(); cmd.CommandText = "sparql insert into graph <ado.net> { <a> <P04> \"123456.12\"^^<http://www.w3.org/2001/XMLSchema#double> }"; cmd.ExecuteNonQuery(); cmd.CommandText = "sparql insert into graph <ado.net> { <a> <P05> \"123456.12\"^^<http://www.w3.org/2001/XMLSchema#decimal> }"; cmd.ExecuteNonQuery(); cmd.CommandText = "sparql insert into graph <ado.net> { <a> <P06> \"01020304\"^^<http://www.w3.org/2001/XMLSchema#hexBinary> }"; cmd.ExecuteNonQuery(); cmd.CommandText = "sparql insert into graph <ado.net> { <a> <P07> \"01.20.1980T04:51:13\"^^<http://www.w3.org/2001/XMLSchema#dateTime> }"; cmd.ExecuteNonQuery(); cmd.CommandText = "sparql insert into graph <ado.net> { <a> <P08> \"01.20.1980\"^^<http://www.w3.org/2001/XMLSchema#date> }"; cmd.ExecuteNonQuery(); cmd.CommandText = "sparql insert into graph <ado.net> { <a> <P09> \"01:20:19\"^^<http://www.w3.org/2001/XMLSchema#time> }"; cmd.ExecuteNonQuery(); cmd.CommandText = "sparql insert into graph <ado.net> { <a> <P10> \"test\" }"; cmd.ExecuteNonQuery(); cmd.CommandText = "sparql define output:format '_JAVA_' insert into graph <ado.net> { <b> `iri($?)` `bif:__rdf_long_from_batch_params($?,$?,$?)` }"; //add Object URI add_triple(cmd, "S01", 1, "test1", null); //add Object BNode add_triple(cmd, "S02", 1, "_:test2", null); //add Literal add_triple(cmd, "S03", 3, "test3", null); //add Literal with Datatype add_triple(cmd, "S04", 4, "1234", "http://www.w3.org/2001/XMLSchema#integer"); //add Literal with Lang add_triple(cmd, "S05", 5, "test5", "en"); add_triple(cmd, "S06", 3, (short)123, null); add_triple(cmd, "S07", 3, 1234, null); add_triple(cmd, "S08", 3, (float)12345.12, null); add_triple(cmd, "S09", 3, 123456.12, null); add_triple(cmd, "S10", 3, new DateTime(2001, 02, 23, 13, 44, 51, 234), null); add_triple(cmd, "S11", 3, new DateTime(2001, 02, 24), null); add_triple(cmd, "S12", 3, new TimeSpan(19, 41, 23), null); add_triple(cmd, "S13", 4, "GpM7", "http://www.w3.org/2001/XMLSchema#base64Binary"); add_triple(cmd, "S14", 4, "0FB7", "http://www.w3.org/2001/XMLSchema#hexBinary"); byte[] bin_val = { 0x01, 0x02, 0x03, 0x04, 0x05 }; add_triple(cmd, "S15", 3, bin_val, null); } catch (Exception e) { Console.WriteLine("{0} Exception caught.", e); } finally { if (c.State == ConnectionState.Open) c.Close(); } } static void add_triple(IDbCommand cmd, string sub, int ptype, object val, string val_add) { cmd.Parameters.Clear(); IDbDataParameter param = cmd.CreateParameter(); param.ParameterName = "p1"; param.DbType = DbType.AnsiString; param.Value = sub; cmd.Parameters.Add(param); param = cmd.CreateParameter(); param.ParameterName = "p2"; param.DbType = DbType.Int32; param.Value = ptype; cmd.Parameters.Add(param); param = cmd.CreateParameter(); param.ParameterName = "p3"; if (val != null &amp;&amp; val.GetType() == typeof (System.String)) param.DbType = DbType.AnsiString; param.Value = val; cmd.Parameters.Add(param); param = cmd.CreateParameter(); param.ParameterName = "p4"; param.DbType = DbType.AnsiString; param.Value = val_add; cmd.Parameters.Add(param); cmd.ExecuteNonQuery(); } } } </verbatim> ---+++Related * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]] * [[VirtRDFInsert][Insert RDF Data into Virtuoso]] * [[VirtTipsAndTricksGuideADONETInsertBynary][Insert binary data to Virtuoso RDF storage in plain queries and with parameter binding via ADO.NET calls]]
sioc:id
0292fc4e0371a2d77ff92e5eb836562e
sioc:link
n4:VirtTipsAndTricksGuideInsertRDFUsingVStudio
sioc:has_container
n7:VOS
n13:has_services
n14:item
atom:title
VirtTipsAndTricksGuideInsertRDFUsingVStudio
sioc:links_to
n4:VirtTipsAndTricksGuideADONETInsertBynary
atom:source
n7:VOS
atom:author
n8:this
atom:published
2017-06-13T05:46:38Z
atom:updated
2017-06-29T07:41:35Z
sioc:topic
n7:VOS